Need to sum a custom field of type 'time'.
We have created a custom field of type 'time'. We would like to sum that field in a report. Do we have to do a conversion of the type 'Time' to use the Sum Function?Thanks!Brian
→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.
We have created a custom field of type 'time'. We would like to sum that field in a report. Do we have to do a conversion of the type 'Time' to use the Sum Function?Thanks!Brian
This report is also highlighted in this blog post.The report gives a top 5 of assets which have the highest average CPU usage as scanned by the performance counters. Please note that performance counter scanning has to be manually enabled. Additional...
Greetings,I'm pretty much a newb, so please be patient with me.We are in the process of doing a refresh that the machines need to meet 4 criteria:OS,HDD,RAM and MS OfficeI have so far figured out most of the things I need in my report, except for the...
Added in v.6.0.100The report below lists Windows computers and gives back their network adapter speed.The report will only list assets that meet all of the following criteria:The computer's state is set to "active".The computer has been successfully ...
I've seen this asked around here before but there wasn't a decent report for something like this yet. I had a need today and found where Lansweeper stores this information and how to interpret it.Select Top 1000000 tblAssets.AssetName, tsysAssetTyp...
I attempted to create an out of warranty report that includes what CPU, free HDD space, and how much memory each computer has. The thing I created works....sort of except it duplicates everything two or three times.Can anyone help?*By create I mean I...
Hi Forum Members!!I was hoping someone could help me out as this goes slightly over my head to creating what I need even after having a go.I am after a report where I can see all tickets with the value of 'Other', this value is under a custom field c...
Good Afternoon,I am not much of a report writer so thought I would ask here. Does anyone have a report that displays only items that show as first seen in the last 3 months. Our network operations center wants information so they can be sure any new ...