• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 538
  • Last Modified:

SMS Reporting on Actual PC Usage

Is there a file/way for SMS to report on that would show the actual PC usage? As in, how many times during the past X months has this machine been turned on/booted up?

We have a few machines in questionable usage locations and it would be nice to have data to show that "these machines havent even been turn3ed on in the past month". It would help around budget time to not spend unwisely! :)

Thanks!

D.J.
0
CRCool
Asked:
CRCool
1 Solution
 
glavinfoczCommented:
About the usage I'm not sure. I think that it is not possible with SMS because the product is not designed for that. This job should be handled by MOM (now SCOM).

As for the history of reboot, SMS can help. SMS regurarly gathers information about computers via HW inventory. And it creates also a history. In HW inventory there is information about last boot up time of Windows. So if you set SMS to do HW inventory each day, it can give you information if the PC is rebooted each day (so you will not know is the PC was rebooted twice or more per day).

So go to SMS console and create a report.
Add a name and category
Click on Edit SQL Query Statement
Into SQL Query Statement copy and paste code below
Click on Prompts
Click on star to create a prompt
Fill in Name and Prompt text as shown on attached picture
Click OK 4x

Hope it will help.


Select 
	s.Name0,
	os.LastBootUpTime0,
	os.installdate0,
	os.TimeStamp
 
From
	v_R_System s
	Left Outer Join v_HS_Operating_System os on
		s.ResourceID = os.ResourceID
 
Where
	s.Name0 = @computerName

Open in new window

SMSReport.jpg
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now