ITNinja

Will this do? Change that 'Orca 3.1' to the software display name you want. Remember to leave the wildcard % at the end of string.

select ASSET_HISTORY.TIME, ASSET.NAME, ASSET_HISTORY.DESCRIPTION
from ASSET
left join ASSET_TYPE on ASSET.ASSET_TYPE_ID = ASSET_TYPE.ID
left join ASSET_HISTORY on ASSET.ID = ASSET_HISTORY.ASSET_ID
where
(ASSET_TYPE.ID = 5
and ASSET_HISTORY.DESCRIPTION not like '%KB%'
and ASSET_HISTORY.DESCRIPTION not like '%reboot%' )
and
(ASSET_HISTORY.DESCRIPTION like 'Found software item Orca 3.1%')
order by TIME DESC

Wsteo,

thanks for this. It works pretty well. The only issue I have is that in the description field it shows everything from Microsoft Office Proof to Microsoft Office Professional Plus 2007. There are a good 15 items in the description field when I replace orca 3.1% with Microsoft Office Professional Plus 2007%.

How do I make it find just Microsoft Office Professional Plus 2007 and show that only in the description field.

I really appreciate this.

Pat

It probably is the wild card filter '%' that selects all other unwanted software titles at the same time. If you want only a particular software, copy and paste the enitre string from Description column. as it checks for string using =, do not miss out even a period.

ASSET_HISTORY.DESCRIPTION = 'Found software item Microsoft Office Professional Plus 2007 in inventory.'

If you are asking me to do this:

Original

select ASSET_HISTORY.TIME, ASSET.NAME, ASSET_HISTORY.DESCRIPTION from ASSET left join ASSET_TYPE on ASSET.ASSET_TYPE_ID = ASSET_TYPE.ID left join ASSET_HISTORY on ASSET.ID = ASSET_HISTORY.ASSET_ID where (ASSET_TYPE.ID = 5 and ASSET_HISTORY.DESCRIPTION not like '%KB%'
and ASSET_HISTORY.DESCRIPTION not like '%reboot%' ) and (ASSET_HISTORY.DESCRIPTION like 'Found software item Microsoft Office Professional Plus 2007%') order by TIME DESC

Edited

select ASSET_HISTORY.TIME, ASSET.NAME, ASSET_HISTORY.DESCRIPTION from ASSET left join ASSET_TYPE on ASSET.ASSET_TYPE_ID = ASSET_TYPE.ID left join ASSET_HISTORY on ASSET.ID = ASSET_HISTORY.ASSET_ID where (ASSET_TYPE.ID = 5 and ASSET_HISTORY.DESCRIPTION = 'Found software item Microsoft Office Professional Plus 2007 in inventory.') order by TIME DESC

I tried it and it failed.

thanks for the help and patience.

pat

I also ran this and the report runs but no data is retrieved.

select ASSET_HISTORY.TIME, ASSET.NAME, ASSET_HISTORY.DESCRIPTION from ASSET left join ASSET_TYPE on ASSET.ASSET_TYPE_ID = ASSET_TYPE.ID left join ASSET_HISTORY on ASSET.ID = ASSET_HISTORY.ASSET_ID where (ASSET_TYPE.ID = 5 and ASSET_HISTORY.DESCRIPTION not like '%KB%'
and ASSET_HISTORY.DESCRIPTION not like '%reboot%' ) and (ASSET_HISTORY.DESCRIPTION = 'Found Software item Microsoft Office Professional Plus 2007 12.0.4518.1014 in inventory') order by TIME DESC

Pat