ODBC drivers export / import

Hi everyone

In some case you might want to export all ODBC configurations from one server to another’s one.

2018-11-21_09-47-02

There is a small handy tip with PowerShell to achieve that goal;

Export the DNS;

Get-OdbcDsn |Export-Clixml dsn.xml

On the other machine, we import it;

Import-Clixml dsn.xml |Add-OdbcDsn

 

Voila, the config is now copied between the computers.

Advertisements
Posted in microsoft | Leave a comment

QuickBook 2019 error on Windows Server 2012 R2..

Hi

If someday you have that setup;

  • Customer with QuickBook on their computer
  • The QuickBook server module

You might hit a small bug when you share your database.

An error code -6000,-83.

The file in the share are created, but not able to be open when the error happen ?

The bug was in the end really simple for me, the quickbook server module does not accept special characters in the folder name..

Renamed the folder with special charracters (é in my case) and voila, it worked..

Posted in microsoft | Leave a comment

Windows netstat tip

Hi

If you debug a lot your Windows computer and you need to issue the netstat -ano command, it’s often hard to see if a services is listening on the correct ports.

I find a small tip to quickly find that information.

In taskmgr.exe you right click the first coloum to display the PID, as such;

netstat02

After that you can see a normal list from netstat -ano;

netstat01

As you can see the list can be quite big, as such the tip is simply to parse the netstat -ano with a findstr command.

That way; netstat -ano | findstr “PID”

I tested it with the PID 5700, the steam client, for that result;

netstat03

As you can see the list is really easier to read with that small tip ! 🙂

 

Thanks everyone

Posted in microsoft | Leave a comment

Windows Server – Log all Active Directory LDAP query

Hi

I wanted to share a small tip if you need to log all LDAP’s query sent to your ADDS’s server.

You can easilly find the correct registry to change there:

You need to set at 5 the key Field Engineering there: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\NTDS\Diagnostics

and you need to set to 1 those two keys:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\NTDS\Expensive Search Results Threshold

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\NTDS\Inefficient Search Results Threshold

For more detail you can find it some documentations there, Creating More Efficient Microsoft Active Directory-Enabled Applications

 

Thanks everyone

Posted in microsoft | Leave a comment

Windows Server 2016 RDP DPI settings

Hi

Today I will share a small tip for settings the DPI settings on a terminal’s session, especially useful if your customers use shared thin client.

On older RDP / TS server, Windows Server 2008 R2 you could apply this KB (You cannot change the DPI setting through a Remote Desktop session on a computer that is running Windows 7 or Windows Server 2008 R2)  that could allow the client to change the DPI’s settings inside the remote session.

In Windows Server 2016 the DPI settings is inherited from the parent device, thus the computer or the thin client.

As such if you want to control the DPI, but you don’t want to change the thin client configuration for everyone, then you can set a GPO with those settings;

HKEY_CURRENT_USER\Control Panel\Desktop\LogPixels
– If LogPixels does not exist then create a new DWORD value
– Type in Decimal Value
96 for Smaller 100%
120 for Medium 125%
144 for Larger 150%

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server\WinStations\IgnoreClientDesktopScaleFactor
– If IgnoreClientDesktopScaleFactor does not exist then create a new DWORD value
– Type in Decimal Value:
Turn on = 1
Turn off = 0

 

Thanks

Posted in microsoft | Leave a comment

WMI spy – Diag WmiPrvSE.exe High CPU Usage

Hi

If you happen to have problem with WMI, as sometime it can use a lot of ressources and you don’t know why, there is a small tip for you.

Did you know you are able to spy on query done in WMI to be able to track down who is the culprit ?

You can use the command:

Wevutil.exe sl Microsoft-Windows-WMI-Activity/Trace /e:true

wmi001

You type yes after.

wmi002

After the command you will be able to see more detail about the WMI call behing made in the system.

Don’t forget to disable it after the diagnostic!

More information there

Posted in microsoft | Leave a comment

Storage Sense GPO

Hi everyone

I wanted to share a small tip to manage Storage Sense settings by GPO;

It’s by registry setting in GPP, as the GPO’s console don’t have any template yet to set them.

Get a user configured with the wanted setting and get that registry hive;

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\StorageSense\Parameters\StoragePolicy

Use those settings in a user GPP and you are all set 😀

Image from there
Posted in microsoft | Leave a comment