How To: What Groups is this Node a Member?

Thanks for the video lag. I encounter a problem when I execute the query in Report Writer if the Where statement is not commented out (get a SQL error) and of course, the report does not display properly on the website.

What could be going on? My SQL looks exactly like yours.

There's a bit of a trick to it. In Report Writer, to validate the query works, you will leave the where clause commented out. Once you're ready to deploy, remove the comment. The report writer will no longer be able to run the report, but it should work in the web console now.

Thought I had done those steps, but I repeated them and now all is well. Thanks again. Great report.

A good way to have this work in a report is to create a stored procedure that just returns the "table" of info.  the report would then call the stored procedure.  This is a good way to run reports that have case statements, if/else, and other TSQL commands that SW doesn't translate

Hi Andrew,

Thanks for sharing this excellent report!

Is there any way to include other group member types like applications, volumes etc?

Regards,

Deltona

This looks good! However, for some reason, I can't link the group name to the group page.

Could you upload the report to Content Exchange so I can see what i'm doing wrong?

Thanks in advance!

I added a report you can try here: Group_Membership_-_Node_Details.OrionReport

Do you mean placing a similar report on an application summary page? I'm sure you could with some minor tweaking. Just guessing, but I bet you could replace the 'WHERE NODEID=${NodeID}" with something like WHERE ApplicationID=${ApplicationID}." Although, the convention might be off a bit, the procedure should work.