As I am creating Software items, some with custom inventory rules and some not, I am wondering how we will be able to find all the "Software" items in the future.  Ex. Show me all Software items, i've manually created, or modified. Apart from labels, smart labels and such. Can be easy if you know what your looking for...

I guess I am thinking that I will not find what I need someday or it will accumulate additional clutter that I want to avoid.


0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

1

I always start all mine with CIR.



You can create a CIR report.  Just change the org# to the org you are in


For our Acad org
SELECT DISPLAY_NAME as Name, INVENTORY_RULE as Rule, CREATED as Date FROM ORG2.SOFTWARE
where (INVENTORY_RULE rlike '^[A-Z]') order by NAME

For our Admin org

SELECT DISPLAY_NAME as Name, INVENTORY_RULE as Rule, CREATED as Date FROM ORG3.SOFTWARE
where (INVENTORY_RULE rlike '^[A-Z]') order by CREATED


Answered 01/26/2016 by: SMal.tmcc
Red Belt

  • the sql is to create a report that will show what you created
Please log in to comment

Answers

0
That is definitely a good idea.  I may start doing that in the future.  Is there any other ways to "sort" the software to show only the ones we modified, or manually created?
Answered 01/26/2016 by: davreh99
Orange Belt

  • Try this.

    SELECT DISPLAY_NAME, INVENTORY_RULE
    FROM SOFTWARE S
    WHERE INVENTORY_RULE != 'NUL'
    • the sql is to create a report that will show what you created
Please log in to comment
0

The above naming convention is a great idea.  It has the advantage of identifying itself as a custom inventory record wherever the software names are displayed (screens, reports, etc.).

I usually place my organization's name in the publisher name field.  It's a unique name and easy to search on.  I then enter that information in the search field and voila.


Answered 01/26/2016 by: kenwhite
Senior White Belt

Please log in to comment
Answer this question or Comment on this question for clarity