While reading chapter 3 of “Pro SMS 2003” by Rod Kruetzfeld’s, Rod touched on one of items that I believe all SMS administrators should do.


To quote Rod,

“IT Management: By all means, allow your IT Management access into your SMS 2003 environment. They can be your best proponent for such tools, especially when supplied with the ability to view queries and web reports. Create some customized reports that suit their specific needs, permits then access, and educate them on how to access these reports. I doubt very much that they will need to view anything else inside the SMS console.”


I will refine this even farther. Give all IT Management, IT Security, Service Desk staff, and Back Office staff FULL access the SMS web reports. Since this is a read only web site they can do any harm to anything.


With everything that I can do and add to the SMS web report such as the “SMS 2003 Web Reporting – Remote Tools Page version 3.21”, I really don’t need to have anyone access the SMS console except for the SMS Admins.


What does it give them?

  • Provide them with access to real-time data.
  • Provide more self serve to access to data.
  • Give them a better understanding of what SMS can report on.


And ultimately show the value of SMS.


The one thing that I miss from the SMS 2.0 days is the ability to have two or more SMS Web reporting sites.


In SMS 2.0 I had one fully public site that anyone could access the data within the SMS database, however they could not see any data about individual PCs. So they could see reports like:


Count of PCs with Modems

Count of Add / Remove products


But a private site which required a network logon could see all reports within the public site and drill through to the underlying reports such as:

List of PC that has Office 2003

List of PC with internal modem installed.