For the enterprise sys admin by the enterprise sys admin
15
Aug
I had a requirement to report on SQL Server installations in our environment as part of our Microsoft EA true-up process. This included SQL 2000, 2005 & 2008 installations. The difficulty was that you can’t run a simple Add / Remove Programs report because it will report all of the SQL client tools installations as [...]
Tags: EA, Enterprise and Standard version installations, Microsoft, MOF, report, SCCM, SCCM report for SQL server Developer, SQL, true up
1
Jun
This report displays the number of servers in the environment and gives a breakdown and percentage view of physical vs virtual: Declare @Total as int Declare @Physical as int Declare @Virtual as int set @Virtual = (Select distinct count (*) From v_R_System full Join v_GS_COMPUTER_SYSTEM On v_GS_COMPUTER_SYSTEM.ResourceID = v_R_System.ResourceID where v_R_System.Operating_System_Name_and0 LIKE ‘%server%’ and v_R_System.Client0 [...]
4
May
I recently had a requirement to be able to email SCCM reports on a schedule in an environment without SQL reporting services. I achieved this by creating a VB script to create an email that has the report ASP page as the body of the email. The script I used and scheduled as a Windows [...]
Tags: automate, automatic, email, email report, report, SCCM, schedule
3
May
In a recent case, I needed to run a report to work out which systems had a particular server (antivirus) installed but was in the STOPPED state. After modifying the sms_mof file: [SMS_Report (TRUE) ] string State; and running a hardware inventory on all machines, I could then create a report with the following query: [...]
Tags: not running, report, SCCM, service, stopped
7
Feb
I recently had a requirement to report on server ages for the machines in our environment. Adding the ‘BIOS Manufacture date’ and ‘OS Install Date’ should be a good indication of this. The query will also return some other helpful fields like model, manufacturer, RAM and processor: SELECT distinct CS.name0 as ‘Server Name’, OS.Caption0 as [...]
Tags: age, install date, report, SCCM, servers
3
Feb
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. [...]
Tags: apple, configmgr, environment, ieee, ipad, iphone, ipod, MAC, OUI, query, report, SCCM, SQL