Yep - quite doable. All you need is a bit of SQL .
Check out this article that I've written here ==> How to find and query Custom Data via SQL -- does that help you?
I'm guessing you've not got a custom table you've created - so you'll need to resolve against the UNMODELEDDATA table.
If you don't know SQL yourself, bribe a friendly DBA with some food / coffe / tea or backrubs (whatever they're into) to help you out. Also - it'd be the perfect opportunity to explain to your boss that you need to learn some rudimentary SQL skills (you don't need to become an admin - just be able to actually use it) and have time / training set aside for it.
VERY much doable though.
As a bonus - here's a nice reference site that I've been using for years to remind me of relevant bits of SQL syntax -- SQL Tutorial
Hope this helps .
Thank you phoffmann for your answer.
But it's not so easy.
We have a SQL-Manager for all SQL-Server and -Applications, and the only way is to beg him to do it. It's a question of rights.
His time is very rare, and this problem has no priority.
And I'll have such things 2 or 3 times in a year.
If I choose "New Text" in the Inventory so i got a new attribute and I can use it for Inventory.
But if SQL-Scripts are the only way , so I havo no chance and should change the value one by one.
It's a pity
Well - if you don't have access to the SQL DB - then yep.
That said - you COULD try and use this scenario as leverage to get read & write rights to the SQL DB via your boss or so. You don't need to become a SQL Server admin - "just" being able to do DB changes is a pretty significant part of advanced LANDesk administration. There's a *LOT* of reasons why you may need to query and/or update things DB-side ... so I'd suggest trying to go the political route.
Especially if this is going to be a recurring task, you're effectively being told to waste a lot of time when it could be "just" a case of running a single script. It's worth trying at least - sometimes good sense prevails.
wenn ihr LDDA Lizensiert habt sollte das ebenfalls gehen. Hier kannst du die Devices dann einfach auf deine Regel ziehen.
das klingt schon ganz gut und so etwa habe ich es mir gedacht.
Wir haben sogar LDDA lizensiert, aber hier hat noch nie jemand etwas damit gemacht, ist also quasi noch im Auslieferungsstatus.
Aber es ist ein guter Anlass, dass ich mich mal damit beschäftige.
Dann kann ich vielleicht beim nächsten Projekt schon damit arbeiten.