Month – January 2013

List Collection Membership

For full details, please see http://www.windows-noob.com/forums/index.php?/topic/7308-collection-membership/#entry27677 select C.Name from dbo.v_FullCollectionMembership FCM join dbo.v_Collection C on C.CollectionID = FCM.CollectionID Where FCM.Name = ‘Gartek-DC’

PC Serial Number by OU.

For full details, please see http://www.myitforum.com/forums/Active-Directory-Discovery-additional-Attributes-and-broken-reports-and-queries-m238462.aspx select distinct R.ResourceID, R.Name0, R.Client0, BIOS.SerialNumber0 from dbo.v_R_System AS R LEFT OUTER JOIN dbo.v_RA_System_SystemOUName AS OU ON R.ResourceID = OU.ResourceID INNER JOIN dbo.v_GS_PC_BIOS AS BIOS ON R.ResourceID = Bios.ResourceID where OU.System_OU_Name0 = N’GARTEK.TST/DOMAIN CONTROLLERS’

Finding all PCs without Symantec AV installed

For Full detail see http://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/thread/547016e0-9f15-4611-aac9-24f582aa0614   select R.netbios_name0, R.user_name0, OS.Caption0 AS ‘Operating System’, ES.SerialNumber0 AS ‘Serial Number’ from dbo.v_R_System R join dbo.v_GS_OPERATING_SYSTEM OS on OS.ResourceID = R.ResourceID JOIN dbo.v_GS_System_Enclosure ES on ES.ResourceID = R.ResourceID where R.ResourceID not in ( select distinct ARP.ResourceId From dbo.v_ADD_REMOVE_PROGRAMS ARP join dbo.v_GS_System S on ARP.ResourceID = S.ResourceId where ARP.DisplayName0 in […]