Browse by Tags

Query for a portion of a NetBIOS Name

select * from dbo.v_GS_COMPUTER_SYSTEM where name0 like '___m%'

Posted to Garth Jones (Weblog) by Garth on 03-11-2010
Office Count

select DisplayName0, Version0, Count(*) From dbo.v_Add_Remove_Programs ARP Where DisplayName0 like '%office%' Group by DisplayName0, Version0 Order by ...

Posted to Garth Jones (Weblog) by Garth on 03-01-2010
Customized Report "computers with specific software registered in Add Remove Programs"

SELECT Distinct sys.Netbios_Name0, fcm.SiteCode, sys.User_Domain0, sys.User_Name0, sys.Operating_System_Name_and0, arp.DisplayName0, u.department0...

Posted to Garth Jones (Weblog) by Garth on 02-14-2010
2010 myITforum Donation

With the start of a new year, it is that time again to support the System Management Community, with that in mind I have made my yearly donation of $250 USD to MyITForum (MIF). Why do I do it? Well as a past User Group leader for www.OWSUG.ca , I know how much it cost to host a small user group community...

Posted to Garth Jones (Weblog) by Garth on 01-07-2010
management nightmare

SELECT Distinct R . Netbios_Name0 , ARP . DisplayName0 , OS . Caption0 FROM dbo . v_R_System R INNER JOIN dbo . v_GS_ADD_REMOVE_PROGRAMS ARP ON R . ResourceID = ARP . ResourceID INNER JOIN dbo . v_GS_OPERATING_SYSTEM OS ON OS . ResourceID = ARP . ResourceID WHERE ARP . DisplayName0 in ( 'Microsoft...

Posted to Garth Jones (Weblog) by Garth on 12-23-2009
Limiting to a Collection.

SELECT Distinct R . Netbios_Name0 , ARP . DisplayName0 FROM dbo . v_R_System R INNER JOIN dbo . v_GS_ADD_REMOVE_PROGRAMS ARP ON R . ResourceID = ARP . ResourceID Inner Join dbo . v_FullCollectionMembership FCM ON R . ResourceID = FCM . ResourceID and CollectionID = 'SMS00001' WHERE ARP...

Posted to Garth Jones (Weblog) by Garth on 12-14-2009
Why v_GS_OPERATING_SYSTEM.Caption0 is better than v_R_System.Operating_System_Name_and0

Take the following query, if you only used v_R_System . Operating_System_Name_and0 then you would have no idea as to which PCs are installed with “Microsoft Windows 7 Ultimate" or “Microsoft Windows 7 Professional”. Select R . Name0 , ...

Posted to Garth Jones (Weblog) by Garth on 12-04-2009
Servers Report Query

SELECT R.Netbios_Name0, os.Caption0, ARP.DisplayName0 As 'Softwarename', ARP.Publisher0 as 'Publisher', ARP.Version0 as 'version', ARP.ProdID0...

Posted to Garth Jones (Weblog) by Garth on 12-04-2009
List of PCs not listed v_R_System

select CS . name0 as 'PC name' , WS . LastHWScan as 'Last HW scan Date' from dbo . v_GS_COMPUTER_SYSTEM CS join dbo ....

Posted to Garth Jones (Weblog) by Garth on 11-23-2009
How to Perform a Basic Software Audit (Query)

Quick follow up to How to Perform a Basic Software Audit Do you want to know how many ARP entries you have? How many page of paper you will get if you print all of the entries? What about bundles of paper? Use this query to help you determine this for you. declare @ARP BIGINT Set @ARP ...

Posted to Garth Jones (Weblog) by Garth on 10-31-2009

Page 1 of 29 (286 items) 1 2 3 4 5 Next > ... Last »