Report Writer specific time frame format help..?

Question

The field under the Time Frame tab in report writer says "Starting Date/Time" and then below it "Ending Date/Time"  I tried entering this format as I need to find results for a query for 1 P.M. to 3 P.M. yesterday.

Starting Date/Time: 7/23/2007/1300

Ending Date/Time: 7/23/2007/1500

The message I get is: "The Ending Date/Time for this report is before the Starting Date/Time."

Now...to me it seems like I should be getting results for my query that correspond to 7/23 between 1 and 3 P.M. but I can't get the right syntax to get rid of this error. Can someone please help me out with this?

njoylif · Answer

That's an excellent site.  I didn't know that part was there!  Thanks Mark.

mark_wiggans · Answer

You will need to know some SQL, Click on NEW and Advanced SQL- and enter the CPU, MEM, HD variable strings- for what it is you are trying to achieve.

This may help you down this pathhttps://www.solarwinds.com/resources/video/how-to-use-the-solarwinds-orion-report-writer

Video Resources – SolarWinds

You can also check out these customer submitted reports to see how others have customized their reports-

http://thwack.com/files/folders/orion_custom_reports/default.aspx

HTH

Rush_2112 · Answer

Yes!  Thank you.  That works.  I have one other very related question that I don't want to clutter the forum up with a new thread for.  How can I get values such as CPU, MEM, HD space, etc in the same report?  If I go to New Report I have to choose a type, and this is great but depending on the type I choose there are different options in the Select Fields tab when I'm building the report.  But I want to correlate several things for one box at one point in time, is there a way to get CPU, MEM, traffic, disk usage, etc for one time period on one report?  I can do several reports and export to excel and then cut and paste but this seems overly complicated.  I was hoping there was a more efficient way.  Thanks you.