Return
-
Title
Where are the stored procedures mentioned in the Reporting and Trending Guide? -
Description
Where are the stored procedures mentioned in the Reporting and Trending Guide?
For example, it mentions to run "exec spotlight_get_datasources". Where do I find the 'spotlight_get_datasources' stored procedure?
-
Resolution
The stored procedures such as 'spotlight_get_datasources' are part of the Spotlight Statistics Repository database.
You can execute it by running "exec spotlight_get_datasources" in SQL Server Management Studio (SSMS) in the context of the Spotlight Statistics Repository (SSR) database.