Grab your flagon o' grog and hoist ye colors! I'm going to cover some easy reports you can create in the Notification Server that should be of use to at least a few people here. When you are writing queries for the helpdesk you often may need to know a contact ID or a worker/queue ID. I have written 2 reports that you can run from the NS that will give you a list of all the active workers/queues and their worker numbers, as well as the contacts.
The first thing you need to do is go to your NS Console and create a new report. To do this in console 6.0 you simply go to the reports tab, right click on the folder under "Reports" where you want the report to appear and select "New" and then "Report" from the right click menu. You can always move the report later from the same menu if you want to place it somewhere else.
A report builder dialog box will come up and present you with some options for building your new report. Give the report a name that makes sense to you; I named mine "Worker Names and ID's". You can give the report a description, this is useful for later identifying why the report was created and what it's for. Finally you need to select the "Enter SQL Directly" radio button and enter the following query:
USE Altiris_Incidents SELECT name as 'Worker Name', id as 'ID Number' FROM dbo.worker WHERE status like 'a' ORDER BY name
You can click Test to make sure your query is working, it should display all your users/queues and show their worker ID number. Click finish once you're satisfied with it and it will create the report and you can then run the report anytime you need to lookup a worker/queue ID.
If you also want one for contacts this is very simple. Just change the line in the above query "dbo.worker" to "dbo.contact" so it would look like this:
USE Altiris_Incidents SELECT name as 'Contact Name', id as 'ID Number' FROM dbo.contact WHERE status like 'a' ORDER BY name
The best example I can give of where this is useful is in writing an Incident Query in the Helpdesk that shows all open tickets for all the users at a particular office. You could immediately know what their worker ID is after running this report, instead of having to connect to the table and run the query by hand.