Calculation of Open Tickets on Incident Window

If you are 7.3 then a calculation could do this

I was trying to do the same thing and have an old post that still has no replies

It is possible to use a calculation but because there is no way to filter the data, this is a bit harder to do.  I know that I can scan thru every record and count the open incidents for my raise user.  But to do this I would have to go through every record.  Right now I have just 10,000 records after about 3 months of use.  The thought of searching 100,000 records or 1,000,000 records every time I edit an incident seems kind of disk intensive.  Now add 40 analysts doing the same thing and I think my system is going to slow down a bit.

I know I have a query at the bottom of my screen that's called "By User".  That query will have anywhere from zero (best case) to maybe 100 records to search.  Great, my filter has already been done, all I have to do is search that data.  Opps, you can't do that.  The queries at the bottom are not available to BOO.  Neither the LANDesk helpdesk or I have found a way to get BOO to run a SQL statement or do any type of filter to help me out.

If anyone has found a way to get BOO to access SQL, I would love to see some examples.

http://boo.codehaus.org/ADO.NET  Has some links to BOO and databases but 2 of the 5 links are broken.

Hi Mark, Carl,

Unfortunately this isn't possible via a calculation or other method.  The reason is there is no direct link from the user to the incidents, its a one way connection going in the wrong direction for what you need.

You can technicailly make a SQL connection from a calculation but for performance I would not recommend attempting it.  Using the count from the query at the bottom of the incident window will be your best option.

Thanks

I came to the same conclusion.