Machines not restarted X days

[SEC_ALERTS]

Hi Team,

If possible ,We need report for those machine which are not restarted since 7 days.

Regards,
SEC_ALERTS.

[Hemoco]

dstjames wrote:
How would you restrict this to only computers or even better only workstations since I dont need to know when my servers or networking equipment last rebooted?

Do the following:
• Run the report.
• Double-click on tblComputersystem in the table list on the right to add it to your report.
• In the visual representation of the report in the upper section of the report builder, tick the Domainrole field in tblComputersystem to add it to your report.
• Add the below criterion to the Criteria column for the tblComputersystem.Domainrole expression. TblComputersystem data is pulled from the Win32_ComputerSystem WMI (Windows Management Instrumentation) class. The following Microsoft knowledge base article explains what each Domainrole value means: http://msdn.microsoft.com/en-us/library/aa394102%28v=vs.85%29.aspx

<2

[dstjames]

How would you restrict this to only computers or even better only workstations since I dont need to know when my servers or networking equipment last rebooted?

[SEC_ALERTS]

It Works!!
Thanks a lot !!!

[Hemoco · Accepted solution]

A sample report can be seen below. Note that uptime information won't be accurate unless your machines have recently and successfully been rescanned. You can rescan assets by clicking the Assets link at the top of the web console, ticking the checkboxes in front of the assets and hitting the Rescan button on the left.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
Convert(Decimal(6,2),tblAssets.Uptime / 60 / 60 / 24) As Uptime
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where Convert(Decimal(6,2),tblAssets.Uptime / 60 / 60 / 24) > 7 And
tblAssetCustom.State = 1
Order By tblAssets.IPNumeric