I need my service desk to generate asset tags automatically as and when I create new assets in CMDB. However, I am facing challenges and need advise.
There's a logic behind asset tag generation. Every asset type has a shortcode, say for example Desktop has a shortcode "DTP", laptop has shortcode "LPT". These shortcodes are defined on Configuration Item Type Reference Object.
Similarly, every company has a shortcode, say for example Ixtel has a shortcode "IXT", Idara has a shortcode "IDR". These shortcodes are again defined on the company object (under groups).
Every asset record that is created will have company information as well.
So, if the first desktop entry is created and company selected is Ixtel, it's asset tag should be populated as IXT-DTP-0001
Now, if the second desktop entry is created and company selected is Idara, it's asset tag should be populated as IDR-DTP-0001
If I create a third desktop entry and company is selected as Ixtel, it's asset tag should be populated as IXT-DTP-0002
The same needs to apply for all the asset types as well.
Any design ideas are welcome.