Folks,

new to KACE but learning fast. I've asked this question at Support and they basically are saying "it's in there" or "it's possible". Here's what I've posed to them. I'm installing Office 2007 on roughly 2200 machines and would like to produce a report that shows when a client had the package installed and how long it took. Does any one know of any canned or user created report that does that? I've been going crazy trying to generate one. I'm trying to justify the KACE appliance in terms of saving time and money installing software using it versus having a computer specialist install it.

Any aid would be greatly appreciated.

regards,

Pat
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
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
Answered 10/04/2010 by: wsteo
Senior Yellow Belt

Please log in to comment
0
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
Answered 10/04/2010 by: pkarr@mcallenisd.net
Senior Yellow Belt

Please log in to comment
0
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.'
Answered 10/04/2010 by: wsteo
Senior Yellow Belt

Please log in to comment
0
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
Answered 10/04/2010 by: pkarr@mcallenisd.net
Senior Yellow Belt

Please log in to comment
0
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
Answered 10/04/2010 by: pkarr@mcallenisd.net
Senior Yellow Belt

Please log in to comment
Answer this question or Comment on this question for clarity