How do I create a report from query builder that remains current and not static?

[Robert Campbell]

When using query builder, I have the query I want but the results are tied to when the query is run.  So if I create a report from that, it looks at that specific data that has that query record, not how it may actually be today.

Is there a way to get the results from the last time it was run?  Something like Created most recently?

[Maik Skoddow · Accepted solution]

Hi @Robert Campbell 

yes, this is possible and described on https://docs.servicenow.com/bundle/quebec-servicenow-platform/page/product/configuration-management/...

Maik

[Robert Campbell]

I followed those instructions but it creates a report that has a specific condition of Query Sys ID = ...  The next time that schedule runs, there will be a new Sys ID so this report would no longer be valid, right?

When I try to use it in PA, I have to specify the Query Sys ID else it will give results of all Query Sys IDs.

Report:

PA Indicator Source:

[Robert Campbell]

Although this did answer the question; the problem now is that users can't view the data.  The only way that users can view the data is if they first go to the query and open it.  Then they will be able to view the data on the report.  It's not even that they can still see the old data, they get security restraints. Once they open the query, the data shows.  They need to do this every day.