UIM SQL Prob

[mustafa.waqar]

Hi,  Can we monitor DB user activities with UIM Sql probe?  Thanks,  Waqar

[Charles Nack]

Waqar, are you asking if you can monitor UCM DB users activity with UIM Sql Probe or is this a general UIM SQL Probe question?

 

I believe you may have posted this in the wrong forum and want to confirm so we can have it moved to the correct section to best assist you.

[mustafa.waqar]

Hi Charles,

 

 

My question is :

 

 

Does Microsoft SQL prob monitor user activity in Microsoft SQL DB, for

example which user deleted DB table, which user created DB table in MS SQL.

[Charles Nack]

Hello Waqar,

It looks like this was incorrectly opened in the wrong forum, this is the Unified Communications Monitor (UCM) section and you need the Unified Infrastructure Management (UIM) forum.

I will have them move this over there for you.

I also did some quick research and it doesn't look like it monitors user activity.

Here is a link to the release notes from the probe:

 

https://wiki.ca.com/display/UIMPGA/sqlserver+%28SQL+Server+Monitoring%29+Release+Notes

[mustafa.waqar]

Thanks a lot dear.

[Legacy User]

Hi Waqar,

 

SQL probe will not do what exactly you are looking for,

From user point of view it can do response time monitoring, also it provides you the facility to write your own query in case you feel that can give you desire result and run it on regular interval.

 

Regards

Ajit C

[Anon Anon]

I don't believe any probe does that out of the box. You could use sql_response to examine the transaction log of a database and alert on that, but you'll need to come up with the query yourself.

 

-jon