
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-27-2013 05:43 PM
Hi Team,
If possible ,We need report for those machine which are not restarted since 7 days.
Regards,
SEC_ALERTS.
If possible ,We need report for those machine which are not restarted since 7 days.
Regards,
SEC_ALERTS.
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-27-2013 06:03 PM
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
4 REPLIES 4

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-08-2013 07:14 PM
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

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-08-2013 07:05 PM
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?

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-01-2013 10:22 AM
It Works!!
Thanks a lot !!!
Thanks a lot !!!

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-27-2013 06:03 PM
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
