Notification Rules Data Storage
This issue has been solved. See solution.
mccarthy.cw
June 24th, 2009
Where is the data stored regarding notification rules?
Filed under: Helpdesk Solution, Endpoint Management and Virtualization
wu_custom_instance
All of the rules are stored in the "wu_custom_instance" table of your Altiris_Incidents database.
select * from wu_custom_instance where custom_processor_id = 100 --Notify Rules
select * from wu_custom_instance where custom_processor_id = 200 --Routing Rules
select * from wu_custom_instance where custom_processor_id = 300 --Tasks
select * from wu_custom_instance where custom_processor_id = 400 --E-mail Inbox Filters
select * from wu_custom_instance where custom_processor_id = 500 --Incident Rules
select * from wu_custom_instance where custom_processor_id = 600 --Validation Rules
select * from wu_custom_instance where custom_processor_id = 700 --Automation Rules
Awesome. I was hoping to
Awesome. I was hoping to make some clean-up activities that are needed when an employee leaves the company easier. I recently had to find rules, reports etc. that were creating notifications to a certain employees email. Instead of having to go through the entire console to find this information I was hoping to be able to write a query that will point me to the correct objects way faster.
So now I can use a query like
SELECT name
FROM wu_custom_instance
WHERE custom_processor_id = 100
AND valuetext like '%joesmith@gmail.com%'
to find any notifications that an employee was receiving.
Would you like to reply?
Login or Register to post your comment.