Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Please help with custom report

All,

I have a report that I need to do based on the hours of 8 AM - 5 PM to get the full amount of bandwidth used per site. I have a 7 days report that seems to work great, but I can't figure out how to query only between 8 - 5. Has anyone got an example? When I try to modify the report in notepad and then bring it into report writer, report writer overwrites the custom query that I did.

Thanks,

John

Find more posts tagged with

Accepted answers

berger

Would this work for you?

TimeFrame->Reletive Time Frame->Past 9 hours
Then go to job scheduler and set it to send you a report every day at 5.

If not then I would suggest changing it to an Advanced SQL:

Go to the top bar -> Report -> Show SQL
When in design view hit the SQL tab -> Copy all of the SQL
Create a new advanced SQL report, paste it in there

You can also paste SQL on here, and it should be fairly easy change to make it only show 8AM to 5PM for the current day.

All comments

berger

Would this work for you?

TimeFrame->Reletive Time Frame->Past 9 hours
Then go to job scheduler and set it to send you a report every day at 5.

If not then I would suggest changing it to an Advanced SQL:

Go to the top bar -> Report -> Show SQL
When in design view hit the SQL tab -> Copy all of the SQL
Create a new advanced SQL report, paste it in there

You can also paste SQL on here, and it should be fairly easy change to make it only show 8AM to 5PM for the current day.

FormerMember

If not then I would suggest changing it to an Advanced SQL:
Go to the top bar -> Report -> Show SQL
When in design view hit the SQL tab -> Copy all of the SQL
Create a new advanced SQL report, paste it in there

This is the part that I'm having a problem with currently. It won't let me edit the SQL statements at all. I can't type or paste data under the SQL tab. I can only view what's there, and that's including creating a new report. Maybe I'm doing something wrong, but I can't see how......

Thanks,

John

FormerMember

Ah....ADVANCED SQL REPORT....yeah, that made a difference Let me play with that and get back with you! Thanks!