All that CMPivot query does, is query the Win32_OS class aka the exact one used by HW inventory, so there is no difference between the two results.

Question 0 Sign in to vote Dear All, I want to write the query to get the whole unit column as per below table is calculated whole unit column in Excel

My question was is it possible to query site specific DNS settings via vbscript . we have many windows machine across 9 regions and each region has different DNS servers.

Hi, I'm facing an issue of sharing the workbook I created using a power query from an SQL server cube. The query was modified in power pivot to add new columns and calculated fields, then summarized …

May I know the version of Excel and PostgreSQL that you are using? As far as I know, we usually use Power Query to connect PostgreSQL database, did you use this method?

Thanks for your question. I am sorry that you cannot solve the problem by using SQL. Microsoft's KB315071 explains how to view and set LDAP policy in Active Directory by using Ntdsutil.exe.

could someone,help me on how to query sms DB about specific registry key.

I'm using a simple PowerShell script to query Active Directory for a couple of extensionAttributes. What I thought would be a simple afternoon's testing has turned into a three-day nightmare. The results I get …

This post explains the settings about iOS supervised mode in Intune, and how to enable supervised mode.

The query for all record containing "PC" is not the problem... but I have problems to check the ownership for all results now...