Ability to extract DMIDs of items through Reports

[mpasumarti]

FLC administrators most often require to run specific clean up activities on whole bunch of items in a workspace. For example, i needed to run script (which is registered as an external script on items in Items & BOMs workspace) to set a group as an additional owners to open up access to that group. This activity required DMSIDs of bunch of items which meet the criteria to trigger an external script registered on items through a power shell script. The power shell script has a feature to process specific items given their DMSIDs.

If there would have been a feature to extract DMSIDs of bunch of items through Reports, my job would have been easy. As a workaround to this problem i implemented an external script with required conditions to get to the applicable items by inputting DMSIDs of all items or released items. This process is really time consuming. I have been told by the Autodesk consultants to adopt to this workaround because finding an item by DMSID is quicker than finding an item by its properties such as Number, Name, Release Letter, etc. is time consuming.

[richard.valdez]

we needed this as well so we created a section of our Item Master that is called system information. on this section we have the DMSID listed and the Netsuite ID for our ERP system. by having these listed in the Item Master, we can then run a report on that field and sort within Excel. this also helps me findout which items failed to bridge into the ERP system because if the item is missing a Netsuite ID then I know the bridge is not working! 

[gasevsm]

Richard, Simply create a number field in hidden section and set the dmsid with oncreate event. Then can report on it no problem. HTH,

[mpasumarti]

@gasevsm, That's a good suggestion. But, it requires some effort to implement it. As a customer I look for majority of the key features as part of the product (in other way i call it as ease of use) than implementing workarounds for each of the requirement which i come across. I hope you agree with me on this.

[gasevsm]

You wont find disagrement with me on that ;). In lack of native system access to items' dmsids, this is as good and tried and true practice; nevertheless, your requirement is duly noted. Regards,

[katelyndwilson]

@gasevsm - this is still something we would love to see done.  Having a field isn't always sufficient, especially for rev-controlled workspaces.  Having this accessible as a computed field and/or report field would be incredibly beneficial for clients.

[benderk]

Thank you for submitting your idea. Have you tried the Modern Interface lately? We request that you review your idea in the context of the Modern interface. If your idea is not addressed, we invite you to create a new Idea in the context of Modern so that it can be addressed accordingly. Sincerely, Keri Bender | Global GTM Business Strategy Manager, Product Lifecycle Management

[mstoneformation]

Sad that this was archived and never implemented - it had nothing to do with the modern interface. Will log new idea!