Browse by Tags

All Tags » SCCM » SQL (RSS)
Find Programs Removed from a PC (updated)
Monday, May 21, 2012 10:15 AM
For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/db96da44-a9e0-4996-bca2-286b6e2c473a SELECT DISTINCT CS.Name0, HARP.Publisher0 AS ' Publisher ', HARP.ProdID0 AS ' Product ', HARP.DisplayName0 AS ' Name ' FROM dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_ADD_REMOVE_PROGRAMS ARP on ARP.ResourceID... Read More...
by Garth Jones
Filed under: , , , , , , ,
List of PC with Project and Subnet
Thursday, May 03, 2012 8:04 AM
For full details, see posts: http://www.myitforum.com/forums/SCCM-report-m235714.aspx http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/07158c51-06e1-4afb-8a46-187eaf8e82eb   select Distinct CS.Name0 from dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_Add_Remove_Programs ARP on CS.ResourceID = ARP.ResourceID join dbo.v_GS_NETWORK_ADAPTER_CONFIGUR... Read More...
by Garth Jones
Filed under: , , , ,
Last Reboot Report
Sunday, March 18, 2012 12:38 PM
For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/e0147d8a-8946-42bb-b6ed-a3c92bae5b23   select distinct R.ResourceID, R.Netbios_Name0 AS ' Computer Name ', OS.LastBootUpTime0 AS ' Last Boot Time ', R.Resource_Domain_OR_Workgr0 AS ' Domain/Workgroup ', S.SiteCode as ' SMS Site Code... Read More...
by Garth Jones
Filed under: , , , , ,
Lists people and how much they've been using specified software with OU fix
Friday, March 16, 2012 6:53 PM
For full details see: http://www.myitforum.com/forums/tm.aspx?high=&m=234978&mpage=1#234980   select U.Name0 as ' Bruger ', -- U.displayName0 as 'Bruger', MU.FullName as ' Brugernavn ', ou.ou as OU, round( sum (MUS.UsageTime)/60.0,2) as ' Forbrug (min) ' from dbo.v_R_System R join dbo.v_MonthlyUsageSummary MUS on R... Read More...
by Garth Jones
Filed under: , , , , ,
Lists people and how much they've been using specified software
Friday, March 16, 2012 6:40 AM
For full details see: http://www.myitforum.com/forums/Need-some-SQL-help-think-its-simple-m234978.aspx   select U.Name0 as ' Bruger ', -- U.displayName0 as 'Bruger', MU.FullName as ' Brugernavn ', replace( max (ou.User_OU_Name0),' ITCSYD.LOCAL/BRUGERE/ ',' ') as OU, round( sum (MUS.UsageTime)/60.0,2) as ' Forbrug... Read More...
by Garth Jones
Filed under: , , , , ,
Report for matching names
Monday, March 12, 2012 11:53 AM
For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/8bda0fe9-7d80-44d0-9a52-f1f573423abf/   select CS.ResourceID, cs.NAME0, PC2.name0, substring (CS.NAME0,5,LEN(cs.NAME0)) from dbo.v_GS_COMPUTER_SYSTEM CS, ( select CS.ResourceID, cs.NAME0, substring (CS.NAME0,5,LEN(cs.NAME0)) as ' TAG ' from dbo.v_GS_COMPUTER_SYSTEM... Read More...
by Garth Jones
Filed under: , , , , ,
Link v_MeteredUser.FullName to a full name from ad
Monday, March 12, 2012 8:34 AM
To see the full post http://www.myitforum.com/forums/How-to-link-v_MeteredUserFullName-to-a-full-name-from-ad-m234899.aspx select R.Netbios_Name0 as ' Computernavn ', -- U.displayName0 as 'Bruger', Full_User_Name0, MU.FullName as ' Brugernavn ', MUS.LastUsage as ' Sidst brugt ', MUS.UsageCount + MUS.TSUsageCount as ' Antal... Read More...
by Garth Jones
Filed under: , , , , , ,
BIG NEWS!!!!
Sunday, March 11, 2012 10:40 PM
I have big news but there is a catch….. I can’t say much until Wednesday at noon PST! J Which works out perfectly, as that is almost the exact time that I will be finishing my SCCM Guru webcast! So make sure that your register for the session to hear it Live! http://bit.ly/yMimvp   oh, you want a hint?!?! Just a little hint??? Let’s just say that it involves... Read More...
by Garth Jones
Filed under: , , , , , , , , ,
Link to Name
Sunday, March 11, 2012 11:32 AM
For full details see post here. http://www.myitforum.com/forums/tm.aspx?high=&m=234875&mpage=1#234894   select ARP.resourceid, CS.Name0, max (ARP.version0) as JavaVersion from dbo.v_GS_COMPUTER_SYSTEM as CS join dbo.v_ADD_REMOVE_PROGRAMS as ARP on CS.ResourceID = ARP.ResourceID where ARP.DisplayName0 like ' Java(TM) 6 Update% ' group by ARP... Read More...
by Garth Jones
Filed under: , , , , ,
Cannot get rid of duplicate rows on an Add or Remove Programs query
Sunday, March 04, 2012 4:52 PM
For for details see post. http://social.technet.microsoft.com/Forums/en-US/configmgrinventory/thread/3bea8fa6-968a-4f0e-b412-469577e409aa Select DISTINCT SYS.Netbios_Name0 AS ' Name ', case SEM.ResourceID When NULL THEN ' N ' Else ' Y ' End AS ' SafeNet? ', ARP. Timestamp From dbo.v_R_System SYS left outer JOIN dbo.v_Add_Remove_Programs... Read More...
by Garth Jones
Filed under: , , , ,
Custom ChassisType Report - wrong counts
Sunday, March 04, 2012 12:30 PM
See the full details within the forum http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/d8477233-4b10-4a6d-a5ea-de73abc9b815/ declare @Manufacturer0 as varchar (250) set @Manufacturer0 = ' All ' declare @Version0 as varchar (250) set @Version0 = ' All ' declare @CollectionID as varchar (250) set @CollectionID = ' SMS00001... Read More...
by Garth Jones
Filed under: , , , , ,
Software Metering Test query
Friday, March 02, 2012 2:39 PM
select CS.Name0, MRIB.ProductName, MD.* from dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_MeterData MD on CS.ResourceID = MD.ResourceID join dbo.v_MeterRuleInstallBase MRIB on MD.FileID = MRIB.MeteredFileID where MD.starttime > ' 2012-02-16 ' Read More...
by Garth Jones
Filed under: , , , ,
Tips and Tricks for SSRS
Friday, February 24, 2012 5:27 PM
I want to let everyone know that I will be giving a webcast on SSRS Report Writing for CM07/CM12 on Wednesday, March 14, 2012, at  11:00 a.m. to 12:30 pm PST.    Episode 9: Garth Jones A Deep Dive into SCCM Data! Bring Your Snorkel!   In this session, I will dive deep into the depths of ConfigMgr, and show you tricks that can be used for both... Read More...
by Garth Jones
Filed under: , , , , ,
ONE Row for each Server
Thursday, February 23, 2012 9:12 PM
For full details see the forum post. http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/bbc5e667-085f-47a2-a5b6-8a5089aa9e91 SELECT Distinct R.Name0 as ' PC ', LD.FreeSpace0 as ' Free Space ', LD. Size 0 as ' Size ', isnull(Share.Path0,' n/a ') as ' Path ' FROM dbo.v_R_System R inner join dbo.v_GS_SERVICE... Read More...
by Garth Jones
Filed under: , , , ,
Display the User Group Name in 1 column
Friday, February 17, 2012 8:43 AM
To see full forum post see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/986960ba-8a50-4e69-9e5a-64a40c9d8df5/ SELECT R.User_Name0 as ' user name ', U.Full_User_Name0 as ' full name ', U.givenName0 as ' First Name ', U.sn0 as ' Surname ', U.mail0 as ' Email ', max (OU.User_OU_Name0) as '... Read More...
by Garth Jones
Filed under: , , , , ,
More Posts Next page »
Go

This Blog

Syndication