Skip to main content
Solved

deconfigured SQL agent report

  • October 17, 2022
  • 1 reply
  • 81 views

Forum|alt.badge.img+10

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

 

 

Best answer by christopherlecky

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. 

View original
Did this answer your question?

1 reply

christopherlecky
Byte
Forum|alt.badge.img+17

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings