Reporting Group

Hi 

Can we get a report of Last reboot time of the systems.

Need for patching policy

https://www-secure.symantec.com/connect/forums/how-create-report-show-last-time-client-computer-was-restarted

This post may help accomplish what you are looking for.

You can also find the embedded report under:

Reports -> Discovery and Inventory -> Server -> Computer Reboot History

But this is for Servers only...fyi.

Hi JMS97

Though the report is for Servers but that also showing blank in the report

and we looking for clients system

the key table/View is  vOSOperationSystem or Inv_OSOperating_System. It has the Last Boot Up time.

This can be found in Resource Manager for a computer

Try this query... Throw this query in a Altiris Report.

select

vc.name as [Computer Name]

,vc.[OS Name]

,vc.[User]

--,b.[Last Boot Up Time]

,ISNULL(CAST(b.[Last Boot Up Time] AS NVARCHAR), '') as 'Last Boot Up Time'

from vComputer vc

join vOSOperatingSystem b on b._ResourceGuid = vc.Guid

order by ISNULL(CAST(b.[Last Boot Up Time] AS NVARCHAR), '') desc

Yep, please see my eariler post. 

Here is also a query you can try.

select

vc.[Name],

vc.[OS Name],

vc.[User],

os.[Last Boot Up Time]

from vcomputer vc

left join Inv_OS_Operating_System os on vc.Guid = os._ResourceGuid

where IsManaged = '1'

order by os.[Last Boot Up Time]

Hi WDRAIN

I have use above SQL Query but the Last Boot up time showing is incorrect.

CBZ9104,

The data from the Last Reboot time will be based on the Last Inventory from the scheduled Inventory Policy, so the data will not be real-time.

Hi wdrain1

Yes i can understand just i wanted to say that the SQL which we currently using and the one which you provided both giving different boot time and date for the same machines

Hello CBZ9104,

What is the table that your SQL query is pulling from ?

I took the table from jms97 query "Inv_OS_Operating_System" and compared it to the "vOSOperatingSystem"  view  (this view should include the Inv_OS_Operating_System) table and in my environment it had the same time.

select

c.name as [Computer Name]
,os.[Last Boot Up Time]
,vos.[Last Boot Up Time]
,datediff(MINUTE,os.[Last Boot Up Time],getdate()) - datediff(minute,vos.[Last Boot Up Time],GETDATE()) as differences

from vComputer c
join Inv_OS_Operating_System os on os._ResourceGuid = c.Guid
join vOSOperatingSystem vos on vos._ResourceGuid = c.Guid