Hi
Am looking to develop a simple custom report that can show computer name, room, user name, application, and date of installation. However, I would like to develop the report using html and table format. Here is the code that I have been working so far, but cannot get the bes properties that can pull the name of the application and the date of installation.
| Computer Name |
Room |
User Name |
Application |
Date |
<?Relevance
concatenation of
(html it) of unique values of (it as string) of
trs of (
td of item 0 of it &
td of item 1 of it &
td of item 2 of it &
td of item 3 of it &
td of item 4 of it
)
of
(
name of it,
value of results (it, bes properties "Computer Manufacturer - Windows") | "",
value of results (it, bes properties "Room") | "",
value of results (it, bes properties "User Name"),
value of results (it, bes properties "Installed Applications - Windows"),
value of results (it, bes properties "Date"),
((now - last report time of it)/day) as string
)
of bes computers whose (not exists (properties whose (name of it equals "VMWare" AND name of it equals "Server") of property results of it))
?>
/