Assigned To Property in Reports
Created: 02 Feb 2012 | 8 comments
I'm kinda stumped at the moment on how to get this field to show up in the reports. It's in the List Open Incidents by Analyst report however if I create a new standard report and click the Add Tasks to Report it doesn't show up there. Does anyone know the secret on getting this show up? I know I can copy and modify the existing reports but I'd like to know why it doesn't appear on the list to select.
Thanks
Discussion Filed Under:
Comments
SQL
What you may want to do is open the Report Designer on that report and choose the Display SQL option to see how it is structured. You could then compare it to the SQL of the new report. I have noticed that, unfortunately, some elements of the canned reports are not reproducible in custom reports without doing it via raw SQL. If you have a good understanding of structuring queries, that might just give you what you need to make thge report you want by making a new report with the SQL Query data source. I hope that helps!
I looked at
I looked at the SQL for the reports and attempted to write some of my own bu the issue is I can't figure out how to pass in the current user parameter into the query as it appears it's done in the background when the report is run. Do you know how to get the current user parameter to be used in custom SQL queries?
I like my beats fast and my bass down low
Actually I think its there.
Actually I think its there. In most of my reports its called "Task Assignments". All they've done is change the name. If you click on that little blue icon you can change the title. As soon as you do it resorts the list alphabetically. Looking at the SQL of 2 reports it appears to me that regardless of the name it refers to [dbo].GetTaskAssignments(Task0.TaskID) as [Task.TaskAssignments]. I think all Symantec has done is take the standard Task Assignments column and labeled it Assigned. Give it a shot an let us know.
You might be
You might be correct on that and I'll try it when I get back into the office. The one thing that really bugs me about the reports is that sometimes the options for more data is not available. Take for example the My Queues report, it's missing the Process Management, Incident Management and others that you can't select from as it doesn't show up on the left hand side.
I like my beats fast and my bass down low
I agree, some of the
I agree, some of the pre-built reports are missing some options. On top of that, if you try to duplicate the settings in a new report, not only will you see the missing options but depending on the order which items are selected you will see different results. And, on top of that, some of the selections you make don't result in the right outputs. If you look at the SQL statements you will often see a join not happening where it should or boolean operators not being placed where they should. We saw this when trying to come up with a report to see closed incidents by analyst in a specific group. In this case we had to go to custom SQL to get the results we wanted. I suppose installing IT Analytics will help with this but that's a different story all together.
Current User
I think I have to write my own SQL queries in order to get the reports that I want since the built in ones just aren't robust enough. Were you able to get the current user running the reports in order to use that in the query? Looking at the SQL statements for the reports I don't see how they get that information as it seems it's done in the background somewhere when you open the report.
I like my beats fast and my bass down low
It's in Process Management
Add Process Management to the report, then the Assigned to Me and Assigned to Users checkboxes (we left it as assigned to any users, but you can narrow it down in there if you choose). On the right side after you've added them you should see the Assigned To property. Actually, I think it just keys off of the Assigned to Users piece, but we have both checked so that's why I mention it.
If I'm coming in way too late on this, my apologies. Just started coming back to the Connect Forums after a long SD implementation. :)
Hope this helps.
I really hope in the next
I really hope in the next update/release the product team will add these kind of things. When you write your own SQL it is hard to add variables to reports for other users to use who don't know SQL.
Would you like to reply?
Login or Register to post your comment.