I am trying to create a report on 'Asset Covered' table combining asset and its related CI info. Without adding asset.quantity, serial number columns does not show any serial number. However I do not want to show quantity in the report. I know there is an ACL on quantity which basically says if the quantity is less than 1, do not show serial, however in our case quantity is 1 and it does not show any serial number when quantity field is not added as a column. Thanks in advance.
After making alm_asset.serial_number (read) acl inactive, i can see serial numbers in the report. This acl comes active with the system. Here is the acl description.
I can see the purpose - if you don't have 1, or more than 1 of something then you shouldn't populate a singular serial number on the asset form, but this doesn't seem like it's intended to prevent viewing on a report. I created a report on cmdb_ci in my PDI and I'm not seeing anything in the asset serial number column unless I also add the asset quantity field to the report. If the report is on the alm_asset table, then serial number displays without quantity, so the ACL is only affecting reports when dot-walking, which doesn't sound like something that would be intended. I would put in a HI ticket to get their official answer on this, and change the report to run on alm_asset and dot-walk to the CI if possible, otherwise keep the ACL inactive. Another work-around is to change the condition on the ACL
