Custom Icons in PDQ Inventory

No, at this time custom icons cannot be added.

I didn't even know about the ability to change icons until this past week. The available icon selections is very limited (no laptops...)

It would be great if I could use the logo for each of my sites since they all have their own logo's/mascots.

I know this is an old topic but...My Inventory tree is getting pretty large and if I had some meaningful icons to identify certain groups that would be awesome.  I'd like to be able to add product specific (custom) icons as mentioned by the OP.

Yes, me too!

I'm trying to use the ones provided but its just not really enough. would be nice if we could load our own images of a specific size (or even have the program resize on import).

another thing I would like to see is the option to have all child collections set to its parent icon unless specifically set. I just finished changing around 100 of them and it took FOREVER! If that's not an option what about allowing us to select multiple and then change the icon once for all selected?

You can change the icon with SQL. It's the IconKey column in the CollectionDisplaySettings table.

I opened an internal feature request ticket for custom icons.

I tried editing the SQL table and didn't have any luck.  Is there some instruction you found on the PDQ site?

No, there are no instructions that I'm aware of. I'm working on it right now. It's more difficult than I thought it would be :)

WARNING: Please back up your collections and database before running this! If I did something wrong, it could destroy something.

I couldn't figure out a way to do this natively in SQL, so I wrote a quick and dirty PowerShell script. Set your desired collection name and IconKey and it will change all the collections under it to that icon.

$Collection_Name = "Test"
$Icon_Key = "Stock0510"

$Child_Collection_IDs_SQL = "SELECT CollectionId FROM Collections WHERE Path LIKE '$($Collection_Name)%' ORDER BY CollectionId;"
$Child_Collection_IDs = sqlite3.exe "C:\ProgramData\Admin Arsenal\PDQ Inventory\Database.db" "$Child_Collection_IDs_SQL"

ForEach ( $Child_Collection_ID in $Child_Collection_IDs ) {

    $Insert_SQL = "INSERT OR REPLACE INTO CollectionDisplaySettings (CollectionId, IconKey, DisplayType, SortOrder)
        VALUES ($Child_Collection_ID, '$Icon_Key', 'Normal', '');"

    sqlite3.exe "C:\ProgramData\Admin Arsenal\PDQ Inventory\Database.db" "$Insert_SQL"

}