SQL Querys to the database
Some time (more often) there are request of specific reports from the SEPM.
Also often the reports from SEPM dont have all the criterias we need.
So I have started to create a "portal" outside the SEPM interface.
A portal that are "asking" question direct to the SEPM SQL database and then show the result on the portal.
The portal is then use for easy and fast get clean report just what they ask for.
Is there anyone that has been involed to this time of report issues, and if you maybe have writen a sql query that show good/important information.
Maybe we can share some sql querys, the sql querys I am working on right now is to have SEM_AGENT, SEM_COMPUTER and SEM_CLIENT , translated with the help of "inner/outer/ joins etc.
Anyone that are doing the same job?