reporting question
Is it possible to set up inventory reports that can report on a specific piece of hardware or software. For instance be able to report back all of the machine that have adobe acrobat installed?
0 Comments
[ + ] Show comments
Answers (4)
Please log in to answer
Posted by:
tayana
15 years ago
I have used this, however I need a report I can hand to my supervisor.
Posted by:
cblake
15 years ago
Sure- you can use the report wizard to easily generate such a report and have it automatically emailed to you and your supervisor on a regular schedule.
Posted by:
licht
15 years ago
Here the SQL statement you can add in KBOX Reporting :
select
MACHINE.NAME as MACHINE_NAME, SYSTEM_DESCRIPTION, IP, SOFTWARE.DISPLAY_NAME as SOFTWARE_NAME
from SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE
where
MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and
MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID and
(SOFTWARE.DISPLAY_NAME like 'Adobe Acrobat%')
order by MACHINE_NAME
Hope it helps
select
MACHINE.NAME as MACHINE_NAME, SYSTEM_DESCRIPTION, IP, SOFTWARE.DISPLAY_NAME as SOFTWARE_NAME
from SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE
where
MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and
MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID and
(SOFTWARE.DISPLAY_NAME like 'Adobe Acrobat%')
order by MACHINE_NAME
Hope it helps
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.