-
Well it is official, I wrote the Administering and Deploying System Center 2012 beta exam back in February. This morning, I finally got the email that says that I passed the exam. Woohoo.. ;-)
-
Out of Office funny. The funny part about this out of office message, they sent me an email yesterday and they wanted me to reply yesterday! Go figure. (I replied today )
-
For full details see forum post http://social.technet.microsoft.com/Forums/en-US/configmgrsdk/thread/8d8cabc9-5b7b-477b-8443-c6c2abae64c2/#4b6c6e69-adee-4f6b-b51d-da941d1dcf41 Select left (DisplayName0,14), count ( distinct ResourceID) as ' client...
-
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...
-
Well MMS 2012 is over and it has been crazy for me. Here is the summary of what happened: My passport expired so had to get a new one, I picked it up on Thursday just before I left for Vegas I know my luggage would be close to being overweight...
-
For full details see the forum post: http://www.myitforum.com/forums/Query-to-report-Machines-Platform-information-m235322.aspx Select Name0, SystemType0 From dbo.v_GS_SYSTEM
-
For full details please see: http://www.myitforum.com/forums/query-to-report-OU-information-for-Machines-m235317.aspx select R.Name0, max (OU.System_OU_Name0) From dbo.v_R_System R join dbo.v_RA_System_SystemOUName OU on OU.ResourceID = R.ResourceID...
-
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...
-
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...
-
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)...
-
For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/370ceff1-0f54-46f3-8e8e-5459069125e4 SELECT C.Name, OS.Caption0 as ' Operating System ', OS.CSDVersion0 as ' Service Pack '...
-
I have been told that we are 78 people short of the 1200 people for tomorrows Webcast! Will you be the one to help set a new record for myITForm webcast? Sign up now! http://bit.ly/yMimvp And don’t forget that I have BIG news to spill at the end...
-
For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/2ed1b090-2b2b-4a3f-9359-e1ac5fd0adba SELECT DISTINCT SYS.Netbios_Name0, CS.Manufacturer0, BIOS.SerialNumber0, fcm.SiteCode, ROUND( CONVERT ( FLOAT...
-
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...
-
See forum post for full details: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/51ead03a-a43d-46df-b0ab-059d9322e432 SELECT DISTINCT R.Name0, R.User_Name0, ARP.DisplayName0 AS [Software Name], ARP.Version0 AS [Installed...