Michael Sharp Posted July 11, 2018 Share Posted July 11, 2018 See attached report - I have users in multiple account groups and need to remove all the duplicate assets in this report. I need to remove certain teams from the report please. Cheers, Mike. classic-view---laptops.report.txt Link to comment Share on other sites More sharing options...
Victor Posted July 11, 2018 Share Posted July 11, 2018 @Michael Sharp - I do not have the data you have in the system so I am not exactly what results and how the results are returned... Can you give me on or two examples (perhaps screenshot) of what results you get and how you woudl want them returned? Link to comment Share on other sites More sharing options...
Michael Sharp Posted July 13, 2018 Author Share Posted July 13, 2018 See attached - I want to be able to remove Helpdesk 1st, 2nd, Training and Mobile Phone Users sections of the report because they are duplicates. Please can you remove the attachment once reviewed as I'm unable to PM you. Cheers, Mike. Link to comment Share on other sites More sharing options...
Michael Sharp Posted July 13, 2018 Author Share Posted July 13, 2018 @Victor Link to comment Share on other sites More sharing options...
Victor Posted July 13, 2018 Share Posted July 13, 2018 @Michael Sharp attachment removed... sorry for not being able to PM, my Inbox seems to be always full... too many messages and I fail manage the Inbox Link to comment Share on other sites More sharing options...
Victor Posted July 13, 2018 Share Posted July 13, 2018 @Michael Sharp the reason why your report was including these teams is because the filter was not actually excluding them... there is a very important thing missing in the filter which is the use of brackets when mixing AND and OR operators due to how operator precedence works... the screenshot will explain this better. Also in the screenshot I have simplified some of the criteria like h_sys_groups->h_name and h_cmdb_asset_types->type id. I have also noticed that some of the JOIN conditions on the tables were inefficient (using the LIKE operator) so I corrected these as well. Here is a copy of teh report reflecting all the changes: classic-view---laptops-v2.report.txt. Let me know how it works. Link to comment Share on other sites More sharing options...
Michael Sharp Posted July 30, 2018 Author Share Posted July 30, 2018 On 7/13/2018 at 5:05 PM, Victor said: @Michael Sharp the reason why your report was including these teams is because the filter was not actually excluding them... there is a very important thing missing in the filter which is the use of brackets when mixing AND and OR operators due to how operator precedence works... the screenshot will explain this better. Also in the screenshot I have simplified some of the criteria like h_sys_groups->h_name and h_cmdb_asset_types->type id. I have also noticed that some of the JOIN conditions on the tables were inefficient (using the LIKE operator) so I corrected these as well. Here is a copy of teh report reflecting all the changes: classic-view---laptops-v2.report.txt. Let me know how it works. Absolutely perfect thanks, and thanks for the explanation. Is there a way of adding the date to this report? Regards and thanks, Mike. Link to comment Share on other sites More sharing options...
Victor Posted July 30, 2018 Share Posted July 30, 2018 @Michael Sharp apologies, what date is this? Link to comment Share on other sites More sharing options...
Michael Sharp Posted July 30, 2018 Author Share Posted July 30, 2018 13 minutes ago, Victor said: @Michael Sharp apologies, what date is this? The date the report is run please? Link to comment Share on other sites More sharing options...
Victor Posted July 30, 2018 Share Posted July 30, 2018 1 minute ago, Michael Sharp said: The date the report is run please? @Michael Sharp You would like to have this in the title? Or... ? Link to comment Share on other sites More sharing options...
Michael Sharp Posted July 30, 2018 Author Share Posted July 30, 2018 Just now, Victor said: @Michael Sharp You would like to have this in the title? Or... ? In the footer would be preferable please? Is it possible to also add the report name? Link to comment Share on other sites More sharing options...
Victor Posted July 30, 2018 Share Posted July 30, 2018 Hmm... not sure about this... perhaps @TrevorKillick would have a better idea? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now