SQL to limit "Report from Orion Report Writer" to Group members.

Anyone?

Have you searched through the Report Lab forum yet?  If not, check it out.  You might find some helpful stuff in there. :)

Thanks,
DH

It sounds like you are trying to dynamically generate a report based on the group page that you are viewing.  From what I understand of the report writer you won't be able to do dynamic report generation like that.

The best that you could do was create whatever report you want then use a WHERE clause to only show the results for that particular group.  Once the initial report is created it would be trivial to duplicate it for the other groups (only one or two changes necessary for each one).  That would likely be the best that you could do to have each group view with its own report.

I know this is not possible in the report writer itself, but when adding a "Report from Orion Report Writer" View you have the option to add some SQL to filter the results.

When your looking at the details of a node theres variables you can use such as ${IP_Address} to pull that information from the database.

Is there such a variable available I can use to limit what the report is run on when looking at a group view. So far I'm creating report views for the 150+ customers we have, I'd like the ability to create one set of reports and display it on the groups view page and filter it to show only devices in the group your looking at.

Yes, this is possible. When I tried it, I needed to put the condition in the report itself. When you put the report in the "Report from Orion Report Writer" resource on a Group Details page, the ${Name} macro will be replaced with the name of the current group. You can use this in a condition in the report filter, like this:

THANK YOU!

This is exactly what I was looking for. =D

How did you get Group Name & ${Name} in there?

For group name to show up you have to select from the What type of report would like to create box to start the report as Groups:Current Status of Group Members.  You can enter the ${Name} variable into the is equal to box when you add that condition.

Pretty slick tdanner :^}

I had to think that through for a second.

WOW this is very nice!

Is there a way to define a 'default value' ?

As it is, it will work wonderfully from the node page, but if I try to view the report from orion report writer, no "${NodeID}" macro will be resolved, resulting in an error.