Report Filter Help

[Michael Sharp]

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

[Victor]

@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?

[Michael Sharp]

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.

[Michael Sharp]

@Victor

[Victor]

@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  

[Victor]

@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. 

[Michael Sharp]

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.

[Victor]

@Michael Sharp apologies, what date is this?

[Michael Sharp]

13 minutes ago, Victor said:

@Michael Sharp apologies, what date is this?

The date the report is run please?

[Victor]

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... ?

[Michael Sharp]

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?

[Victor]

Hmm... not sure about this... perhaps @TrevorKillick would have a better idea?