in

SMSUG.ca

...your virtual communITy
All Tags » Code (RSS)

Browse by Tags

  • ConfigMgr / SCCM Documentation Script v1.24

    The ConfigMgr / SCCM documentation script has been updated to v1.24 for more details please see http://tinyurl.com/yfpgocw
    Posted to Garth Jones (Weblog) by Garth on 03-02-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

  • Routers?

    This might NOT list all routers in your environment, and it will has lots of false positives too.   Of the 7 device marked as a router, only 3 are right, the remaining 4 are false positives.   In my test lab it found 3 out of 7, Routers /Switches.   Plus it lists ·        ...
    Posted to Garth Jones (Weblog) by Garth on 01-20-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

  • Collection Query - AD group membership & filter for Add\Remove Programs

    select     R.*  from      SMS_R_System R where     R.SystemGroupName != "GARTEK\\Domain Admins"     and R.ResourceId not in (    select                        ...
    Posted to Garth Jones (Weblog) by Garth on 01-04-2010

  • Null and Not like

    SELECT     DisplayName0,     Count(*) AS 'Count',     Publisher0,     @CollID as CollectionID FROM     v_Add_Remove_Programs arp     JOIN v_FullCollectionMembership fcm on arp.ResourceID=fcm.ResourceID WHERE...
    Posted to Garth Jones (Weblog) by Garth on 12-31-2009

  • 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

  • OS version using v_R_System

    select R . Name0 , R . Operating_system_Name_And0 from dbo . v_R_System R Where r . ResourceId not in ( Select ResourceId from dbo . v_R_System R where r . Client_Version0 <> '' ) and R . Operating_system_Name_And0 <> '' order by R . Name0 , R . Operating_system_Name_And0
    Posted to Garth Jones (Weblog) by Garth on 12-21-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
Page 1 of 28 (271 items) 1 2 3 4 5 Next > ... Last »
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems