Browse by Tags

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...
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...
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: , , , , ,
AD discovery and add the following attributes (givenname, sn, mail & ou) report
Tuesday, February 14, 2012 9:08 PM
For full details see. http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/7f48aa48-d260-4ad1-babc-8b2496d103fb I fix the query to make it work, change OS to a readable name, formatting etc.. SELECT R.Name0 as ' Host Name ', CS.Model0 as ' model ', BIOS.SerialNumber0 as ' SN ', OS.Caption0 as ' OS ', R.User_Name0... Read More...
by Garth Jones
Filed under: , , , , , ,
MyITforum donation for 2012
Monday, January 02, 2012 10:21 AM
With the start of a new year, it is that time again to support the System Center Community, with that in mind I have made my yearly donation of $250 USD to MyITForum (MIF). http://myitforum.com/myitforumwp/aboutus/donations/   MIF is truly a community that helps each other both professionally and personally. But it cost thousands of dollars each MONTH to... Read More...
Query on Prohibited application for specific OU
Monday, November 28, 2011 8:39 AM
Select distinct ou.system_ou_name0, sys.Netbios_Name0, fcm.SiteCode,sys.User_Domain0, sys.User_Name0, -- DATEADD(mi,(usr.lastLogontimeStamp0 / 600000000) - 157258080,0) AS [Last Logon Time Stamp (UTC)], usr.company0, sys.Operating_System_Name_and0, Displayname0, Version0, InstallDate0 FROM dbo.v_R_System sys JOIN dbo.v_r_User usr on SYS.user_name0 = usr.user_name0... Read More...
by Garth Jones
Filed under: , , ,
Show list of computers whithout more than 30 criticals patches not installed
Sunday, November 27, 2011 11:59 AM
select v_R_System.Name0 as ' Computername ', Count (v_StateNames.Statename) as ' Required Updates ' from v_StateNames, v_Update_ComplianceStatusAll Inner Join v_R_System On (v_R_System.ResourceID = v_Update_ComplianceStatusAll.ResourceID) Inner Join v_UpdateInfo On (v_UpdateInfo.CI_ID = v_Update_ComplianceStatusAll.CI_ID) where v_StateNames.TopicType... Read More...
by Garth Jones
Filed under: , , , ,
Don’t you love emails like this one!
Monday, November 14, 2011 10:21 PM
I left ITProTeach (DevTeach) a bit early so that I could head home to pack before my long overdue vacation! After getting back, I found this nice surprise in my inbox!   If you want to download the PPT, you can find it in Enhansoft’s blog http://support.enhansoft.com/Blogs/post/Diving-Deep-in-the-SCCM-data!-Bring-your-Swim-trunks!-e28093-Part-2.aspx http... Read More...
Simple History query
Saturday, October 22, 2011 9:49 AM
Select distinct SD.Name0 'Machine Name' , HARP.DisplayName0 as '32bit' , HARP.Version0, HARP64.DisplayName0 as '64bit' , HARP64.Version0, SD.User_Name0 'User Name' From v_R_System SD Join v_FullCollectionMembership FCM on SD.ResourceID = FCM.ResourceID Join v_Collection COL on FCM.CollectionID = COL.CollectionID left outer join... Read More...
by Garth Jones
Filed under: , , , ,
Advertisements, Programs and Main User of all PC
Saturday, October 01, 2011 10:16 AM
SELECT A . AdvertisementName , A . ProgramName , R . Netbios_Name0 as Computername , SCUM . TopConsoleUser0 as MainUsername FROM dbo . v_R_System_Valid R join dbo . v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP SCUM on R . ResourceID = SCUM . ResourceID join dbo . v_ClientAdvertisementStatus CAS on R . ResourceID = CAS . ResourceID join dbo . v_Advertisement A on A . AdvertisementID... Read More...
by Garth Jones
Filed under: , , , , ,
Serial Number, User Information and installation dates of the software
Wednesday, September 28, 2011 6:28 PM
SELECT adv . AdvertisementName , stat . LastStateName , adv . Comment AS C072 , pkg . Name AS C062 , adv . ProgramName AS C071 , adv . SourceSite , adv . AdvertisementID , se . SerialNumber0 , cs . UserName0 , Stat . LastAcceptanceStatusTime FROM v_Advertisement adv JOIN v_Package pkg ON adv . PackageID = pkg . PackageID JOIN v_ClientAdvertisementStatus stat... Read More...
by Garth Jones
Filed under: , , , , ,
More Posts « Previous page - Next page »

This Blog

Archives

Syndication