As part of the network discovery process, I noticed that it was picking up the iPhone and other Apple machines (Macs, iPads) that were on the corporate network either via being plugged in or on the wireless LAN. Shortly afterwards, there was a requirement to report on all the Apple devices found in the environment. [...]

Share/Save

Continue reading...

I needed a SCCM report to count all enabled users in every domain. This is different to the builtin ‘Count users by domain’ as that one only lists domain users that have logged onto a system (that one is from v_R_System). Query = SELECT Windows_NT_Domain0, count(*) FROM v_R_User WHERE User_Account_Control0 = ’512′ GROUP BY Windows_NT_Domain0 [...]

Share/Save

Continue reading...

I needed to report all machines of a particular hardware model type. This report lists all machines of a particular hardware model (user is prompted to enter model name and is populated by a list of models found in the environment). SQL statement: SELECT SYS.Name0, SYS.Model0 FROM v_GS_COMPUTER_SYSTEM SYS WHERE SYS.Model0 = @variable ORDER BY [...]

Share/Save

Continue reading...

I needed an SCCM report to show the disk space details (total space, free space) for all servers in the environment. I had a look at this post – http://www.myitforum.com/absolutenm/templates/?a=20271 – updated the query and this is the result: SELECT SYS.Name,LDISK.DeviceID0, LDISK.Description0, LDISK.VolumeName0, LDISK.FreeSpace0 as [Free space (MB)], LDISK.FreeSpace0/1024 as [Free space (GB)], LDISK.Size0/1024 as [...]

Share/Save

Continue reading...

I wanted an easy way to know if OS deployments were failing or succeeding. We’ve come up with a good way of sending an email outlining task sequence completion status. In SCCM, create a Status Filter rule by going to Site Database – Site Management – Primary Site – Site Settings – Status Filter Rules. [...]

Share/Save

Continue reading...