![riceanny riceanny](https://community.lansweeper.com/html/assets/User_Avatar.png)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-22-2016 02:07 PM
I have to generate a report to check the power consumption in my company. This is what i need: how many minutes are the desktop computers left turned on between 7 pm and 8 am (overnight to understand)?
The best is to take this info for the last xx days or the last week or the last month.
I'm waiting for your answers.
Thank you to everybody
The best is to take this info for the last xx days or the last week or the last month.
I'm waiting for your answers.
Thank you to everybody
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
‎03-05-2016 11:57 AM
There is no easy way to include the information you are after in a report. TblAssets.Uptime only stores the uptime since the last reboot. There are uptime events (reboots, shutdowns...) stored in tblUptime as well, but there is no easy way to calculate uptime from this for a given time period, using SQL reports. We posted a sample query that summarizes uptime here, but this query only works in the SQL Server database server, will take a long time to run and is not easily customizable.
4 REPLIES 4
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-18-2016 01:31 PM
We don't currently provide support for modifying this report further, unfortunately. As you can tell, this is quite a complicated query and not easily modifiable.
![riceanny riceanny](https://community.lansweeper.com/html/assets/User_Avatar.png)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-07-2016 04:21 PM
How can modify the report to sum only the power on night hours (from 7pm to 8am for example)?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-05-2016 11:57 AM
There is no easy way to include the information you are after in a report. TblAssets.Uptime only stores the uptime since the last reboot. There are uptime events (reboots, shutdowns...) stored in tblUptime as well, but there is no easy way to calculate uptime from this for a given time period, using SQL reports. We posted a sample query that summarizes uptime here, but this query only works in the SQL Server database server, will take a long time to run and is not easily customizable.
![riceanny riceanny](https://community.lansweeper.com/html/assets/User_Avatar.png)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-24-2016 08:42 AM
I tried with that:
The problem is that there is no time limit: if it's possible, i want to check the uptime only during the night (from 7pm to 8 am) and only for a limited period such as the last week or the last month. Can you help me?
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.SP,
tsysOS.Image As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
(Replace(Str(Convert(char(4),Convert(INT,tblAssets.Uptime / 86400)),
4, 0), ' ', '0') + 'd ' + Convert(char(10),DateAdd(s, tblAssets.Uptime,
Convert(datetime2,'0001-01-01')),108)) As UptimeAtScan,
tblAssets.Description
From tblAssets
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Order By tblAssets.AssetName
The problem is that there is no time limit: if it's possible, i want to check the uptime only during the night (from 7pm to 8 am) and only for a limited period such as the last week or the last month. Can you help me?
![](/skins/images/C814C14E754F4012AB6B3098C075832D/responsive_peak/images/icon_anonymous_message.png)