| Author |
Message |
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 21/06/2012 15:32:24
|
Bender-TG
SysAider
Joined: 21/10/2009
Messages: 13
Offline
|
I want to clean up our software products.
As you can see our "install names" are blown up with software no more in use (on picture one only the black bordered entry is still available on any pc)
How we can clean up this list? I didn't found any button for that
Problem is now, that there are more than 6000 entries and it's sometimes very hard to find the correct entry if you have to scroll 10 pages before you can click the correct entry
Best regards
Pedro
![[Thumb - old software.jpg]](/Sysforums/upload/2012/6/21/aea204f8f59435af5260ef4cd4445ab6_7021.jpg__thumb)
|
| Filename |
old software.jpg |
|
| Description |
no more in use software |
| Filesize |
81 Kbytes
|
| Downloaded: |
0 time(s) |
![[Thumb - total.jpg]](/Sysforums/upload/2012/6/21/e5ccbd3d9f01e4c348d1202d79ad337b_7021.jpg__thumb)
|
| Filename |
total.jpg |
|
| Description |
total number of install names |
| Filesize |
12 Kbytes
|
| Downloaded: |
0 time(s) |
|
|
|
21/06/2012 16:10:14
|
CarlH
Elite SysAider
Joined: 30/01/2009
Messages: 178
Offline
|
Looks like they're all contained in dbo.software2install_name
|
|
|
22/06/2012 05:40:48
|
Bender-TG
SysAider
Joined: 21/10/2009
Messages: 13
Offline
|
Nice would be a function in SysAid. I don't know all the 3'000 install names no more needed.
|
|
|
02/08/2012 13:11:57
|
Bender-TG
SysAider
Joined: 21/10/2009
Messages: 13
Offline
|
No suggestions from manufacturer?
|
|
|
02/08/2012 13:43:35
|
Ariel Jupiter
SysAid Customer Relations
Joined: 22/11/2011
Messages: 199
Offline
|
Hi Bender-TG 
The installed names that appear in SysAid are imported from add/remove program of all the workstations that are reporting to the SysAid server.
Meaning all the Assets that have the SysAid Agent installed. Therefore it is not possible to delete entries from the installed names, since it is copied from the add/remove program list from all of the workstations.
However if you encounter an issue that you cannot run the software products report, since there are to many entries, you can remove the hot fixes, and the security update entries.
Please note that you require to have the Manager Dashboard module in order to modify the report.
1. Access the Manager portal (if you don't have Manager permissions, please assign it to yourself in the Administrator properties in the Permissions tab - the last checkbox).
2. In the Manager Portal click on Design Reports. You can create a folder for your custom reports or just click on the root image of the report tree and create a New Report.
3. In the new report screen choose to create a report from a Template, and choose the Asset Details By Date as your source template. Make sure the "Visible" checkbox is selected. Click Save.
4. In the window you will currently open change the name of the report to differentiate it from the standard report.
5. Then click on the "Report Design" tab. Click the link next to "Download Report File" to download the jrxml file to your computer.
6. After downloading the file you can open it in the Notepad or by iReport (version 1.2.3 or older) if you used the notepad find this string $P!{ExtraFilter} in the <queryString> then click enter and put this string in a new row: and c.change_description not like '%Hotfix%'
If you used the iReport, open the file, then click the DataSource in the menu then select Report query and find this string $P!{ExtraFilter} then click enter and put this string in a new row:
and c.change_description not like '%Hotfix%'
7. Save the changes then go back to manager portal-"Report Design" tab choose that file in the Browse window. Click Open to choose it.
8. Click on "Upload Report" button. Then Click "OK".
9. Try to run this report (double click on it from the Design Report page) see if the report generated suits your needs.
Note: if you want to remove more result of the report you could add after the Hotfix row for example:
and c.change_description not like '%Security Update%'
Ariel.
|
|
|
18/09/2012 06:24:51
|
Bender-TG
SysAider
Joined: 21/10/2009
Messages: 13
Offline
|
Hi Ariel
First of all, sorry for my late answer.
Report is fine hide hotfixes but not exactly what I'm looking for.
My problem is software from disabled PC's (found out yesterday). This software is still visible in the list. If there is a possibility to add a filter to show only software where PC is "not disabled" this would help a lot...
BR
Pedro
![[Thumb - all.png]](/Sysforums/upload/2012/9/18/c24cec9afefb0efbf4d833b2e679a389_7021.png__thumb)
|
| Filename |
all.png |
|
| Description |
|
| Filesize |
7 Kbytes
|
| Downloaded: |
0 time(s) |
|
|
|
![[Up]](/Sysforums/templates/default/images/icon_up.gif){kind=icon}
