PC uptime since last boot?

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

PC uptime since last boot?

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> Microsoft Systems Management Server >> PC uptime since last boot?

Page: [1]

Message

<< Older Topic Newer Topic >>

PC uptime since last boot? - 8/11/2008 1:21:17 PM

gkamenjati

Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline

Is there a way to query in SMS2003 SP3 how long the system has been Up since the last reboot, something to give me information like uptime.exe

http://support.microsoft.com/kb/232243

Thank you in advance to all respondants.
Keep up the good work.

Post #: 1

RE: PC uptime since last boot? - 8/11/2008 3:55:57 PM

jnelson993

Posts: 900
Score: 127
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

Field
LastBootUpTime0
located in the view
dbo.v_GS_Operating_System

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to gkamenjati)

Post #: 2

RE: PC uptime since last boot? - 8/11/2008 4:33:37 PM

gkamenjati

Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline

Thx John,

I'm not an SQL kind of guy, if you have time can you tell me how's the web Query code will look like to include computer name # and User name

also to prompt for computer name.

Best Regards
George.

(in reply to jnelson993)

Post #: 3

RE: PC uptime since last boot? - 8/11/2008 4:45:15 PM

gkamenjati

Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline

Also if you can add the "Install Date" field.

Thx Again

(in reply to gkamenjati)

Post #: 4

RE: PC uptime since last boot? - 8/12/2008 8:39:42 AM

gjones

Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline

Don’t take this the wrong way but... Here is a way to get better at TSQL.
http://smsug.ca/blogs/garth_jones/archive/2008/08/12/learning-tsql.aspx

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx

(in reply to gkamenjati)

Post #: 5

RE: PC uptime since last boot? - 8/12/2008 10:02:24 AM

gkamenjati

Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline

No problem at all, I'm thankfull for all the info and support I get from this great site and from people like yourself, Sherry, John, Roger, Rob and Ron; you guys are awsome.

Now back to business as you see from the uploaded image I can do this in the Console Queries but it will be nice to move it to the Web reports, and I'm wondering if there's a Cheat cheat to take the Query Language and move it to the Web Language.

I'll definetly be learning from your SQL links.

Thank you again Garth.

Thumbnail Image

Attachment (1)

(in reply to gjones)

Post #: 6

RE: PC uptime since last boot? - 8/12/2008 10:09:41 AM

gjones

Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline

I don't rember a cheat sheet for WQL to SQL but...

SMS_R_* = v_R_*
SMS_G_* = V_GS_*

If you understand WQL then SQL is very easy to learn, since WQL is a subset of SQL.

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx

(in reply to gkamenjati)

Post #: 7

RE: PC uptime since last boot? - 8/12/2008 11:55:33 AM

gkamenjati

Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline

Thx for the quick tip and as you see from the uploaded image I was able to convert to the Web report.
but the only thing in the report that I wasen't able to do is show the IP Address.
as you see from the web report I had to remove the reference to the IP addresses.
I used many possibilities from the Views and the Coluns but no success.

Web Report:
select distinct v_R_System.Netbios_Name0, v_R_System.User_Name0, v_GS_OPERATING_SYSTEM.LastBootUpTime0, v_GS_OPERATING_SYSTEM.InstallDate0, v_R_System.Client0, v_R_System.Obsolete0, v_R_System.Active0, v_R_System.Operating_System_Name_and0 from v_R_System inner join v_GS_OPERATING_SYSTEM on v_GS_OPERATING_SYSTEM.ResourceID = v_R_System.ResourceId

Console report
select distinct SMS_R_System.NetbiosName, SMS_R_System.LastLogonUserName, SMS_G_System_OPERATING_SYSTEM.LastBootUpTime, SMS_G_System_OPERATING_SYSTEM.InstallDate, SMS_R_System.IPAddresses, SMS_R_System.Client, SMS_R_System.Obsolete, SMS_R_System.Active, SMS_R_System.OperatingSystemNameandVersion from SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId

Thumbnail Image

Attachment (1)

(in reply to gjones)

Post #: 8

RE: PC uptime since last boot? - 8/12/2008 12:01:34 PM

gjones

Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline

quote:

ORIGINAL: gkamenjati
Thx for the quick tip and as you see from the uploaded image I was able to convert to the Web report.
but the only thing in the report that I wasen't able to do is show the IP Address.
as you see from the web report I had to remove the reference to the IP addresses.
I used many possibilities from the Views and the Coluns but no success.

Adding IP address to your reports will give you headaches, so I would stay away from them. In most cases they don't added any value to a report.

It is good to see that you figured out the report you needed.

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx

(in reply to gkamenjati)

Post #: 9

RE: PC uptime since last boot? - 8/12/2008 12:46:41 PM

gkamenjati

Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline

Thx Garth, the only reason I add the IP addresses to my reports is because of our Network is subneted by location and floor, thus this will give me a good Idea the PC location and in some cases I'll compare that to our PC per OU reports too. and as you said it is no biggy.

Thx.

(in reply to gjones)

Post #: 10