Requête pour obtenir la liste des rapports, dossiers, sources de données, etc… du catalogue SSRS. A lancer dans la base ReportServer. /*——————————————————————- [SCRIPT] Query SSRS Catalog [DATABASE] ReportServer [DATEMAJ] 20200228 ——————————————————————-*/ SELECT ItemID, — Unique Identifier [Path], –Path including object name [Name], –Just the objectd name ParentID, –The ItemID of […]
Category : SSIS - SSRS
2 articles
Quelques requêtes pour interroger le catalogue SSIS /*——————————————————————- [SCRIPT] Requêter le catalogue SSIS [DESCRIPTION] Trouver les messages d’erreur [MAJ PAR] DATAFLY – Arian Papillon [DATEMAJ] 20200125 ——————————————————————-*/ SELECT session_id, request_id, physical_operator_name, node_id, thread_id, row_count, estimate_row_count FROM sys.dm_exec_query_profiles ORDER BY node_id DESC, thread_id; SELECT O.object_name AS FailingPackageName , O.object_id , O.caller_name […]