http://www.sysaid.com/Sysforums/posts/list/118.page JForum - http://www.jforum.net I know I can see where the package is installed, but I want to see the users.
This way I can send all users who is using a software package a e-mail when I want to upgrade this package. ]]> http://www.sysaid.com/Sysforums/posts/preList/7340/30799.page http://www.sysaid.com/Sysforums/posts/preList/7340/30799.page GMT http://www.sysaid.com/Sysforums/posts/preList/7340/30806.page http://www.sysaid.com/Sysforums/posts/preList/7340/30806.page GMT On the CI, there is a users field, but this field is blank (looks like it is a manualy field)

Can't see any field that automatic displays which users who is using the software(s)]]> http://www.sysaid.com/Sysforums/posts/preList/7340/30807.page http://www.sysaid.com/Sysforums/posts/preList/7340/30807.page GMT http://www.sysaid.com/Sysforums/posts/preList/7340/30808.page http://www.sysaid.com/Sysforums/posts/preList/7340/30808.page GMT http://www.sysaid.com/Sysforums/posts/preList/7340/30809.page http://www.sysaid.com/Sysforums/posts/preList/7340/30809.page GMT
There is one, through asset management.]]> http://www.sysaid.com/Sysforums/posts/preList/7340/30811.page http://www.sysaid.com/Sysforums/posts/preList/7340/30811.page GMT Once every asset is assigned to its owner, you will be able to see on which assets the software is installed on , and in the column "owner" you will see name of user, once you click on it you will be able to see the details of the user and contact him. ]]> http://www.sysaid.com/Sysforums/posts/preList/7340/30859.page http://www.sysaid.com/Sysforums/posts/preList/7340/30859.page GMT I know it is installed on asset 1, 2,3 and 4. But I want to see a report that it used by userA, userB, userC and userD. (and not by checking each asset).
It is "doable" when it is just 4-5 assets, but if it's installed on 40-50 assets, or 400-500, it's not "doable" to check each asset...]]> http://www.sysaid.com/Sysforums/posts/preList/7340/30860.page http://www.sysaid.com/Sysforums/posts/preList/7340/30860.page GMT
Or to get a report you can use the report wizard:-

Select "Asset" as your main entity
Select "SW Products" as your Secondary entity
Give it a caption like "All possible users of a software product"
Click Next
In step 2
From Available fields select "Product Name (Software)" and "Users Assets"
Group By 1 select "Product Name (Software)"
Click Next
In step 3
Select "Product Name (Software)" and move it across to the visible filters.
Click Finish

Then run your new report and put in the name of the product you want to report on, or use a wildcard "contains" visio

Does that help?




]]> http://www.sysaid.com/Sysforums/posts/preList/7340/30871.page http://www.sysaid.com/Sysforums/posts/preList/7340/30871.page GMT
If I can see who is the owner of the asset in the report, and not who is using the asset - then I think we have it
But, when I change the value in the report from user(asset) to owner(asset) the list just show x-rows with the asset name. I know I have owners on all assets, so shouldn't the report come with SW name and asset owner ?
I tried to add name(asset) to the report, and now I can see the SW product name, and the asset it is installed on - but not the owner.. Why?]]> http://www.sysaid.com/Sysforums/posts/preList/7340/30875.page http://www.sysaid.com/Sysforums/posts/preList/7340/30875.page GMT
It appears that the "Belongs to" field is broken in the report wizard.

If I try just an asset report with only the field "Belongs to" selected it shows no owner names.
]]> http://www.sysaid.com/Sysforums/posts/preList/7340/30888.page http://www.sysaid.com/Sysforums/posts/preList/7340/30888.page GMT
There is a bug in the code that is generated in the script tab by the report wizard.
To fix this, edit the report after creating it (Manager Portal > Design Reports, select the report and click the Modify report button).
On the script tab find selectedFields = "product_name_zzz_Software,username_zzz_Assets";
and replace username_zzz_Asset with userName_zzz_Assets [b](note the capital N for Name)[/b]

do the same for the line that starts
sqlStat = "select s.product_name product_name_zzz_SW,c.username username_zzz_AST

change the username_zzz_AST to userName_zzz_AST

press apply to save the changes and your report should work.


]]> http://www.sysaid.com/Sysforums/posts/preList/7340/30892.page http://www.sysaid.com/Sysforums/posts/preList/7340/30892.page GMT ]]> http://www.sysaid.com/Sysforums/posts/preList/7340/30909.page http://www.sysaid.com/Sysforums/posts/preList/7340/30909.page GMT
selectedFields = "product_name_zzz_Software,users_zzz_Assets";

I'm running 8.1.02.]]> http://www.sysaid.com/Sysforums/posts/preList/7340/30951.page http://www.sysaid.com/Sysforums/posts/preList/7340/30951.page GMT http://www.sysaid.com/Sysforums/posts/preList/7340/30953.page http://www.sysaid.com/Sysforums/posts/preList/7340/30953.page GMT
It's no biggy. I was just wondering why I got a different variable name...

]]> http://www.sysaid.com/Sysforums/posts/preList/7340/30957.page http://www.sysaid.com/Sysforums/posts/preList/7340/30957.page GMT
Ignore everything I said in that last post. ( I have deleted it now so as not to confuse anyone else). That response was for re-creating the problem with a similar issue in the report wizard, this time purchase cost not showing up (http://www.ilient.com/Sysforums/posts/list/6448.page#30947)


Now back to your question,

It's because when I first posted those instructions - we were not talking about the "belongs to" field - we were using "users". larronni modified my original report and was trying to use the owner (Belongs to) field.


To recreate this report in the wizard

Select "Asset" as your main entity
Select "SW Products" as your Secondary entity
Give it a caption like "All possible users of a software product"
Click Next
In step 2
From Available fields select "Product Name (Software)" and "Belongs To (Assets)"
Group By 1 select "Product Name (Software)"
Click Next
In step 3
Select "Product Name (Software)" and move it across to the visible filters.
Click Finish
]]> http://www.sysaid.com/Sysforums/posts/preList/7340/30970.page http://www.sysaid.com/Sysforums/posts/preList/7340/30970.page GMT http://www.sysaid.com/Sysforums/posts/preList/7340/33674.page http://www.sysaid.com/Sysforums/posts/preList/7340/33674.page GMT http://www.sysaid.com/Sysforums/posts/preList/7340/33675.page http://www.sysaid.com/Sysforums/posts/preList/7340/33675.page GMT
Here's a screenshot where I think I should see 'Belongs to' :

[img]http://adm.lacitec.on.ca/~sylvain/SysAidInv.png[/img]

For good measure, here's the first step filled in :

[img]http://adm.lacitec.on.ca/~sylvain/SysAidInv1.png[/img]
]]> http://www.sysaid.com/Sysforums/posts/preList/7340/33841.page http://www.sysaid.com/Sysforums/posts/preList/7340/33841.page GMT
If look at your translation file in the asset fields section does it have a line like:-
asset.belongs.to=Belongs to

or is it translated to something else?

or perhaps upload a copy of your translation file and we can try and work it out.]]> http://www.sysaid.com/Sysforums/posts/preList/7340/33845.page http://www.sysaid.com/Sysforums/posts/preList/7340/33845.page GMT
asset.belongs.to=Owner

I looked at my translation file from may 2010 and also have that same line.

Thanks!]]> http://www.sysaid.com/Sysforums/posts/preList/7340/34226.page http://www.sysaid.com/Sysforums/posts/preList/7340/34226.page GMT ]]> http://www.sysaid.com/Sysforums/posts/preList/7340/34556.page http://www.sysaid.com/Sysforums/posts/preList/7340/34556.page GMT