This content has been marked as final. Show 1 reply
How comfortable are you with custom SQL and SWQL queries? If you are, try this approach:
- Create a query to get the status of your transactions.
- Create a query to get the status of your non-web apps (the Citrix based apps, etc.)
- Make sure that the column names are the same in both queries. You may have to rename columns in the query's SELECT clause to make them match. You may also have to add empty columns as placeholders in one query if there's a kind of data that's just missing (for instance, a transaction has a location on a transaction player, but a regular application monitor doesn't).
- Use the SQL UNION operator to combine the output of the two queries you created. This will give you a single data set that includes transaction monitor status and application monitor status.
- Create your report using the UNION'ed query from step 4.