How to Get Software Assets based on their created date
Robert_Osterberg
Customer Advanced IT Monkey ✭✭✭
How can i get the created date of an software asset either from the DB or the SW item itself. I can se the created date in the History tab of the SW Item but i cannot find it in the DB or the cireson sw asset cubes. Anyone got any idea please share.
0
Best Answer
-
Tony_Collett
Cireson Support Super IT Monkey ✭✭✭✭✭
I have been able to get a few methods that may help you out.PowerShell:
Get-SCSMClassInstance -Class (Get-SCSMClass -Name Cireson.AssetManagement.SoftwareAsset) | select Name, `#TimeAdded
SQL:
SELECT [Name]
,[DisplayName]
,[TimeAdded]
FROM [ServiceManager].[dbo].[BaseManagedEntity]
where BaseManagedTypeId='81E3DA4F-E41C-311E-5B05-3CA779D030DB'
5
Answers
It's important to note that OOB SCSM Software Items also do not have a Created Date column, so this is not exclusive to the way it's been designed by Cireson.
Outside of the history tab, I don't know of any way to get the created date for a configuration item. There would likely be an advanced SQL query to be able to find it, but I'm not well versed in SQL unfortunately.
I'll ask our resident SQL expert and see what he comes back with.
PowerShell:
Get-SCSMClassInstance -Class (Get-SCSMClass -Name Cireson.AssetManagement.SoftwareAsset) | select Name, `#TimeAdded
SQL:
SELECT [Name]
,[DisplayName]
,[TimeAdded]
FROM [ServiceManager].[dbo].[BaseManagedEntity]
where BaseManagedTypeId='81E3DA4F-E41C-311E-5B05-3CA779D030DB'
So a new question. is there a way to find the added configuration ITEM within a SWA?. What i am trying to do is to make a report of a specific PrimaryUser and what Config Items is related to that specific SWA.