| Author |
Message |
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 17/09/2011 16:43:47
|
larronni
Elite SysAider
Joined: 08/06/2010
Messages: 129
Location: Trondheim, Norway
Offline
|
Is there some way I can see who (not where) is using a software package?
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.
|
----
Lars Roenning
Atea AS |
|
|
18/09/2011 15:59:09
|
SylvainG
Elite SysAider
Joined: 26/04/2010
Messages: 117
Offline
|
When you look at the assets having the software installed, it should display a columns with the users who logged on those workstations. If you export that list in Excel format, you could then extract those users. Does that help?
|
|
|
18/09/2011 17:22:39
|
larronni
Elite SysAider
Joined: 08/06/2010
Messages: 129
Location: Trondheim, Norway
Offline
|
The software asset, or the CI?
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)
|
----
Lars Roenning
Atea AS |
|
|
18/09/2011 17:35:55
|
SylvainG
Elite SysAider
Joined: 26/04/2010
Messages: 117
Offline
|
I meant Software Products under Asset Management.
|
|
|
18/09/2011 17:37:29
|
larronni
Elite SysAider
Joined: 08/06/2010
Messages: 129
Location: Trondheim, Norway
Offline
|
No userlist here, just assets this software is installed on.
|
----
Lars Roenning
Atea AS |
|
|
19/09/2011 00:16:43
|
SylvainG
Elite SysAider
Joined: 26/04/2010
Messages: 117
Offline
|
"Is there some way I can see who (not where) is using a software package?"
There is one, through asset management.
|
|
|
20/09/2011 12:28:40
|
jorgiani
SysAider
Joined: 11/05/2011
Messages: 6
Offline
|
In order to see who is using this software , so you'll be able to send that user an email regarding updating software package, you need to connect each asset to the user/owner of that computer/asset. In order to attach asset to a user, go to that asset in the Asset management, choose the user in the "owner" field and save the settings.
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.
|
|
|
20/09/2011 12:32:44
|
larronni
Elite SysAider
Joined: 08/06/2010
Messages: 129
Location: Trondheim, Norway
Offline
|
But what if I want to upgrade Microsoft Project, and I want to inform all user who is using Project (not only the owner of the software package).
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...
|
----
Lars Roenning
Atea AS |
|
|
21/09/2011 00:02:13
|
techguy
SysAid Mod
Joined: 11/06/2008
Messages: 1506
Location: England
Offline
|
One of the things that you can do is add the users field to your asset list by customising the asset list view, and then when you click on software products and select machines using the software, it will list all the users on those PC's as well.
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?
|
Need help? Try the SysAid wiki first! - http://sites.google.com/site/sysaidwiki |
|
|
21/09/2011 07:51:00
|
larronni
Elite SysAider
Joined: 08/06/2010
Messages: 129
Location: Trondheim, Norway
Offline
|
Almost.. 
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?
![[Thumb - owner.PNG]](/Sysforums/upload/2011/9/21/e7a361a0952ed5209b68405f3d8acaa4_9608.png__thumb)
|
| Filename |
owner.PNG |
|
| Description |
|
| Filesize |
18 Kbytes
|
| Downloaded: |
1 time(s) |
|
----
Lars Roenning
Atea AS |
|
|
21/09/2011 18:26:30
|
techguy
SysAid Mod
Joined: 11/06/2008
Messages: 1506
Location: England
Offline
|
I get the same results.
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.
|
Need help? Try the SysAid wiki first! - http://sites.google.com/site/sysaidwiki |
|
|
21/09/2011 19:49:07
|
techguy
SysAid Mod
Joined: 11/06/2008
Messages: 1506
Location: England
Offline
|
I have worked out how to fix it. (it's taken me 2 hours to work it out because it is not documented)
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 (note the capital N for Name)
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.
|
Need help? Try the SysAid wiki first! - http://sites.google.com/site/sysaidwiki |
|
|
22/09/2011 05:47:18
|
larronni
Elite SysAider
Joined: 08/06/2010
Messages: 129
Location: Trondheim, Norway
Offline
|
Thanks - that did work
|
----
Lars Roenning
Atea AS |
|
|
26/09/2011 03:28:07
|
SylvainG
Elite SysAider
Joined: 26/04/2010
Messages: 117
Offline
|
Hi Techguy, I built the report like you mentioned (out of curiosity) and do not see that exact line but :
selectedFields = "product_name_zzz_Software,users_zzz_Assets";
I'm running 8.1.02.
|
|
|
26/09/2011 08:22:04
|
techguy
SysAid Mod
Joined: 11/06/2008
Messages: 1506
Location: England
Offline
|
Post deleted by Techguy - who put the wrong reply in - Sorry! - see my next post!
This message was edited 1 time. Last update was at 26/09/2011 16:31:52
|
Need help? Try the SysAid wiki first! - http://sites.google.com/site/sysaidwiki |
|
|
![[Up]](/Sysforums/templates/default/images/icon_up.gif){kind=icon}
