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.
Expand Post
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]