Configuration Manager provides reporting feature by integrating SQL Server Reporting Services. Refer to – Configure reporting – Configuration Manager | Microsoft Docs
After having configured reporting services, we can create subscriptions in SCCM console to reports from which we want to get updates. This is also a feature from SQL Server Reporting Services, which let us configure the automatic delivery of specified reports by email or to a file share at scheduled intervals. Refer to Operations and maintenance for reporting – Configuration Manager | Microsoft Docs on how to create subscriptions.
We can check the subscription from \Monitoring\Overview\Reporting\Subscriptions in the console. The Status column shows the status of the subscription. It can tell the exact reason in case of errors.
It is quite convenient to verify the subscriptions status from the console. However, I once encounter a weird issue that whenever I clicked on the Subscriptions menu the console crashed. I had no time to debug this crash while it was urgent for me to get a quick result of the subscription result. Where to get the Status of the subscription?
Here is the query you can rely on in such a case –
SELECT
[OwnerID]
,[Report_OID]
,[Locale]
,[InactiveFlags]
,[ExtensionSettings]
,[ModifiedByID]
,[ModifiedDate]
,[Description]
,[LastStatus]
,[EventType]
,[MatchData]
,[LastRunTime]
,[Parameters]
,[DataSettings]
,[DeliveryExtension]
,[Version]
,[ReportZone]
FROM [ReportServer].[dbo].[Subscriptions] ORDER BY LastRunTime DESC;
The LastStatus column shows the exactly the same information as you see in the Status column in Subscriptions in the console. Example (other columns removed from the result) –
| LastStatus |
| Failure writing file \\CONTOSOPS1\temp\ReportsSubs\22.xls : A log on error occurred when attempting to access the file share. The user account or password is not valid. |
| Failure writing file \\CONTOSOPS1\temp\ReportSubs\test.xls : A log on error occurred when attempting to access the file share. The user account or password is not valid. |
This way we do not have to count to SCCM console to get the subscription status of the reports we have subscribed to.
SCCM Monde 