Solved

deconfigured SQL agent report

  • 17 October 2022
  • 1 reply
  • 75 views

Userlevel 4
Badge +9

What report can I run show deconfigured SQL agents from the java console ?

 

 

icon

Best answer by christopherlecky 17 October 2022, 21:12

View original

1 reply

Userlevel 5
Badge +16

You may have to roll your own using a dataset.

The query would look something like so.

use commserv 
SELECT [cl].[ClientName] as 'clientName',
[cl].Id as 'clientId'
FROM [dbo].[CNClientInfoView] as cl WITH(NOLOCK)
INNER JOIN [dbo].[CNIDAInfoView]as iDa WITH(NOLOCK)
ON [cl].[ID] = [iDa].[ClientID]
Where [iDa].[AppTypeID] = 81 AND [iDa].[Status] = 2
ORDER by clientName;

 

Reference this post by @Amanda Tesla  for information on how to create your own report. 

Reply