Want to Know What Assets Are Under Warranty?
I recently received request for a report that would show which of our computers are covered by a warranty. I looked around and didn't see a report off hand (that was not tied to the expiration of the warranty) but I did see a lot of similar reports for expiring leases.
Hopefully my solution to this reporting problem will come in handy for someone else.
My Solution
Change the attached txt file to xml to import into NS.
This report first shows all warranties. Choose a warranty and right click for a drill down to show the active computers that are covered by the warranty.
While I just list the warranty and the computer, to see all the associated fields available, add a * to see all the rows of data that are available.
Here are the two sql queries:
level 0: Select * from vWarranty
level 1: Select vw.name as [Warranty Name], vc.name as [Asset Name] from vwarranty vw inner join inv_covered_hardware ch on vw._resourceguid = ch._resourceguid left outer Join dbo.Inv_AeX_HW_Serial_Number sn on ch.[serial number] = sn.[serial number] left outer join vcomputer vc on vc.guid = sn._resourceguid where vw._resourceguid = %_ResourceGuid%
Then add a drilldown on Level 0 for the resource guid. See screenshot.
| License: | AJSL By clicking the download link below, you agree to the terms and conditions in the Altiris Juice Software License |
| Support: | User-contributed tools on the Juice are not supported by Altiris Technical Support. If you have questions about a tool, please communicate directly with the author by visiting their profile page and clicking the 'contact' tab. |
About Endpoint Management Community Blog
The Endpoint Management Community Blog is the perfect place to share short, timely insights including product tips, news and other information relevant to the Endpoint Management community. Any authenticated Connect member can contribute to this blog.
Comments
Data Class Attribute Requirements
Fellow Juice Members-
Does anyone have any information on how to “UN-Require” a Data Class Attribute from a Base Asset Type?
I have a User-Defined resource type of “server” identified with a base resource type of “Asset” in my Altiris instance. When I attempt to modify information related to a server, such as location, the system is requiring me to enter information such as Subnet and Subnet Mask. We do not require information like Subnet and Subnet Mask and I can not seem to find where to “UN-Require” this attribute. There are many other required attributes that I would like to “UN-Require”, I just can’t seem to locate where to disable this feature.
Any information you can offer would be greatly appreciated, I would be willing to verbally discuss this dilemma if I have not presented my issue clearly enough above…
Thanks!
Jeff Ferguson
if it is an editable data
if it is an editable data class
configuration\resource settings\data classes\ and edit the data class with those attributes - uncheck the not required box.
I hope this is what you were asking.
Thanks,
no results
I am sure that I am missing something but am not sure what. I ran the report but no results were returned. where does this report pull information from?
Altiris Inventory Pack for servers shows wrong license count
My NS 6.5 shows that the license count is exceeded for Altiris Inventory Pack for Servers.
Does anybody know how to check and remove the wrong assets.
We are licensed for 200, it currently shows 203 used, but we have only 10 servers.
Regards
Would you like to reply?
Login or Register to post your comment.