AndreMatsuoka asked a question.
Find Scheduled Reports table "Snow License Manager™" -SQL
I would like to know when a report is created scheduled by the SLM it creates a table or viwer in the database.
Exanple-I created a report with the name below and I want to access the information in this report through SQL.
my goal is to connect PowerBI and develop custom dashboards.
Where I can choose which information is useful according to the client or need.
NOTE: I will not use export save file.
A report that you saved as an own report will be visible in the table dbo.tblSystemUserReports, you can check for CID=1 in that table.
These reports are based on a stock report (see column BasereportID).
The stock reports are listed in the table dbo.tblReport ans usually based on a stored procedure (e.g. StockReportAllApplications).
These stored procedures are comoiled and you can't check what's inside.
Hi, Axell
I found in this table, what I needed. "RsComputerSearch1"
But I don't know how it was created.
RsComputerSearch1 is a view, not a table.
Snow Reports often create temp-tables during execution.
In this case, the base is another view named "dbo.RsComputerSearch". You can check the SQL query that builds this view, but noit sure if you can use this. In my environment, the query throws a parsing error.
To see a list of all scheduled reports you could look at tblReportExportSchedule in the Snow License Manager database. You can also see which user the scheduled report is linked to by looking up the userId e.g. userID=1 is the Administrator. TBLSystemUser
Hi, Jelle,
I need access to the contents of the reports.
Hi Andre,
the content of the reports is created at the time of them running then sent / saved. the content is not saved to any tables.
Jelle
Good morning everyone, I got...
below is what was done
I connected using the queries below within PowerBI, relating the hardware and software inventory, with the custom fields.
#Software#
USE [SnowLicenseManager]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[StockReportApplicationsPerComputer]
@CID = 1,
@UserID = 1,
@Parameters = NULL,
@FromWeb = NULL
SELECT 'Return Value' = @return_value
GO
#HARDWARE#
SELECT * FROM [SnowLicenseManager].[dbo].[RsComputerSearch]