Validity of LastBootupTime0 value
We recently shut down all of our servers for a scheduled power outage in our building. When reviewing the LastBooupTime0 column, I see servers that definitely went down and came back up. The generated list of computers in this query is over 25% of our inventory,
and I didn't see many scan errors, so not sure why there are so many. Here's the query I'm using (borrowed from another thread). Thanks.
Select V_R_System.Name0, v_GS_OPERATING_SYSTEM.LastBootUpTime0 From V_R_System Inner Join v_GS_OPERATING_SYSTEM On v_GS_OPERATING_SYSTEM.ResourceId = V_R_System.ResourceId
Where v_GS_OPERATING_SYSTEM.LastBootUpTime0 <= (GetDate() - 30) order by name0Dan
November 2nd, 2010 5:07pm
I’m not sure what you are looking for but.. It will be as valid as:
·
How often you do hardware inventory
·
How healthy your clients are
http://www.enhansoft.com/
Free Windows Admin Tool Kit Click here and download it now
November 2nd, 2010 6:14pm
I didn't realize this field was related to hardware inventory, but makes sense now that you mention it. The hardware agent only runs every 7 days, which explains a lot of those entries. Thanks.
DanDan
November 2nd, 2010 6:21pm
Recommendation: set Hardware Inventory to daily. Hinv is very lightweight. daily hinv is supportable in every environment I've ever heard of.Standardize. Simplify. Automate.
Free Windows Admin Tool Kit Click here and download it now
November 2nd, 2010 8:30pm
I was wondering how big a hit this was, so thanks for the info, I'll give it a try.Dan
November 3rd, 2010 10:40am