Browse by Tags

Count of PCs by OU v2
Wednesday, March 19, 2014 4:15 PM
  For more details please see: http://social.technet.microsoft.com/Forums/systemcenter/en-US/aea60e7b-a88b-48d8-8cc3-8675097abe62/trying-to-do-a-report-of-sup-failures-by-ou?forum=configmgrinventory   SELECT OU.ou, COUNT (*) AS 'COUNT' FROM dbo.v_R_System SYS join ( select SOU.ResourceID, Max (SOU.System_OU_Name0) as 'ou' from dbo.v_RA_System_SystemOUName... Read More...
Count of PCs by OU
Wednesday, March 19, 2014 2:32 PM
Please see post http://social.technet.microsoft.com/Forums/systemcenter/en-US/aea60e7b-a88b-48d8-8cc3-8675097abe62/trying-to-do-a-report-of-sup-failures-by-ou?forum=configmgrinventory for full details SELECT Max (SOU.System_OU_Name0), COUNT (*) AS 'COUNT' FROM dbo.v_RA_System_SystemOUName SOU JOIN dbo.v_R_System SYS ON SYS.ResourceID = SOU.ResourceID... Read More...
PCs with Either of two applications installed.
Friday, January 24, 2014 2:09 PM
Use this query to determine if a PC has either or both applications installed. For more details, please see http://social.technet.microsoft.com/Forums/systemcenter/en-US/6c4650c7-3246-4e13-a78d-05691c13c89d/duplicate-rows-when-finding-pcs-with-installed-software?forum=configmgrreporting   SELECT DISTINCT R.Netbios_Name0, R.User_Domain0+ '\' + R.User_Name0... Read More...
Limiting a report to a Collection
Monday, January 13, 2014 1:14 PM
For more details please see http://www.windows-noob.com/forums/index.php?/topic/9766-sccm-report-on-collection/     SELECT DISTINCT CS.Name0, R.User_Name0, MAX (SOU.System_OU_Name0) AS Expr1, CS.Description0, CS.Manufacturer0, CS.Model0, BIOS.SerialNumber0 FROM dbo.v_Collection Coll join dbo.v_FullCollectionMembership FCM on Coll.CollectionID = FCM... Read More...
Report to show major Internet Explorer version
Friday, January 03, 2014 7:42 PM
For more details see. http://social.technet.microsoft.com/Forums/systemcenter/en-US/14bb9caa-5f0b-418e-88b5-e359ef6d116b/report-to-show-major-internet-explorer-version?forum=configmgrreporting select SF.FileName, OS.Caption0, replace( left (SF.FileVersion,2), '.' , '' ) as 'IE Version' , Count ( Distinct SF.ResourceID) as 'Total'... Read More...
Count of PC within each OU
Monday, September 16, 2013 10:55 AM
For more detail about this query, please see http://www.windows-noob.com/forums/index.php?/topic/9069-report-count-of-computers-in-certain-organizational-units/ select ou.ou, count (*) as 'total' from ( SELECT sys.ResourceID, max (OU.System_OU_Name0) AS 'OU' FROM dbo.v_R_System AS sys INNER JOIN dbo.v_RA_System_SystemOUName AS ou ON sys.ResourceID... Read More...
Finding all PCs with MSAcess.exe in the All Systems collection
Tuesday, July 30, 2013 8:24 AM
Use this query to find all PCs with MS Access in the All systems collection.   select SMS_R_System.ResourceID, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System... Read More...
Joining Users to a PC
Saturday, July 06, 2013 11:15 AM
Use this query to join Users to PCs Select R.Name0, U.User_Name0, U.Full_User_Name0, U.Unique_User_Name0, U.Mail0 From dbo.v_R_System R INNER JOIN dbo.v_R_User U ON U.Unique_User_Name0 = R.User_Domain0 + '\' + R.User_Name0 .csharpcode, .csharpcode pre { font-size: small; color: black; font-family: consolas, "Courier New", courier, monospace;... Read More...
Video card with Sound card.
Thursday, April 18, 2013 2:50 PM
For full details please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c42ba8cf-02a5-4e2e-8d20-39b05a4a5740   select distinct R.Netbios_Name0 as 'Name' , R.User_Name0 as 'User' , CS.Manufacturer0 as 'Manufacturer' , CS.Model0 as 'Model' , BIOS.SerialNumber0 as 'Serial' , SD.Name0 as... Read More...
Video Card Details v2
Thursday, April 18, 2013 9:28 AM
For full details please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c42ba8cf-02a5-4e2e-8d20-39b05a4a5740 select distinct R.Netbios_Name0 as 'Name' , R.User_Name0 as 'User' , CS.Manufacturer0 as 'Manufacturer' , CS.Model0 as 'Model' , BIOS.SerialNumber0 as 'Serial' , SD.Name0 as 'Processor'... Read More...
Video Card details
Monday, April 15, 2013 7:36 AM
For full details please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c42ba8cf-02a5-4e2e-8d20-39b05a4a5740 select distinct R.Netbios_Name0 as 'Name' , R.User_Name0 as 'User' , CS.Manufacturer0 as 'Manufacturer' , CS.Model0 as 'Model' , BIOS.SerialNumber0 as 'Serial' , SD.Name0 as 'Processor'... Read More...
Find all webcam - SQL
Tuesday, April 02, 2013 8:26 AM
Use this query to find all webcam – SQL reports select CS.Name0, SD.Name0, SD.DeviceID0 from dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_SYSTEM_DEVICES SD on CS.ResourceID = SD.ResourceID Where SD.Name0 like '%Webcam%' Read More...
Find all webcam – WQL
Tuesday, April 02, 2013 8:24 AM
Use this WQL query to find all webcam http://social.technet.microsoft.com/Forums/en-US/configmgrai/thread/fa5fcfe2-69ef-4482-adfc-de25d6d19669/?prof=required select SMS_R_System.Name, SMS_G_System_SYSTEM_DEVICES.Name, SMS_G_System_SYSTEM_DEVICES.DeviceID from SMS_R_System inner join SMS_G_System_SYSTEM_DEVICES on SMS_G_System_SYSTEM_DEVICES.ResourceID = SMS_R_System... Read More...
How to find PCs within an AD container
Saturday, March 16, 2013 9:02 AM
If you need to find all PC within an AD container (not an OU). Use this WQL query to find them. For more details about this request, see the full forum post. http://social.technet.microsoft.com/Forums/en-US/configmgrsetup/thread/9358cee7-75a5-4595-80a3-4016ea572f1b   select SMS_R_System.Name, SMS_R_System.LastLogonUserName from SMS_R_System where SMS_R_System... Read More...
Adding total HDD and RAM size Part 2
Monday, February 11, 2013 8:41 AM
For full details, please see http://social.technet.microsoft.com/Forums/en-ca/configmgrai/thread/7951b781-8354-490b-9b59-4fe4e68d1975 SELECT DISTINCT CS.Name0, CASE WHEN ES.ChassisTypes0 in ( '3' , '4' , '6' , '7' , '15' ) THEN 'Desktop' WHEN ES.ChassisTypes0 in ( '8' , '9' , '10' , '21'... Read More...
More Posts Next page »

This Blog

Archives

Syndication