Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Sql Query SD.

Highlighted
madriss
Occasional Contributor

Sql Query SD.

Hello everyone.
How can I make a query to get all elements and thos attributes that are auditable in SD.
Thanks.
5 REPLIES
madriss
Occasional Contributor

Re: Sql Query SD.

Hello everyone
Please I need to know, how can I make a query to get all elements and his attributes that are auditable in SD.
Thanks.
Venkatesha_1
Esteemed Contributor

Re: Sql Query SD.

Hi,

check the SD Database schema sheet for this.

HTH
Venky
madriss
Occasional Contributor

Re: Sql Query SD.

Hi Venkatesha.
Thanks for responding.I want comment you that Audit rules are java objects, and can't be obtained with a sql query. I don't know what is the solution to get this information and I think that you don't know it also.
The Pike
Honored Contributor

Re: Sql Query SD.

You simply cannot do it via a query. Standard SQL cannot unmarshall java objects, so you would have to find a way to deserialize the objects once retrieved.

There was a pretty cool workaround to kinda achieve it for Scheduled Tasks referenced here in the forums but I was not able to find it quickly enough.

The Pike
madriss
Occasional Contributor

Re: Sql Query SD.

Hi The Pike.
Yes I remember this workaround, but I didn't find it neither. I hope they are someone who can give me an idea.
Thanks.
//Add this to "OnDomLoad" event