Is there any way to include assets that are anything other than active? I'm finding some of our inventory being deployed is creating a new asset when re-imaged and I need to identify them. I changed
Code:Where tblState.Statename = 'Active'
to
Code:Where tblState.Statename <> 'Junk'
Junk is a state we added for assets to be disposed of. Regardless, the report is missing some assets. Any ideas what I am doing wrong here?