Hello All,Can someone help me with the fix script to remove duplicate asset tag records in alm_hardware table and here Iam looking to delete the duplicates which are created by leading and trailing spaces in the asset tag. Thank you.
.
how to do normalized when in core_company_list normalized is false
Hello Experts, SAM-Calculate Asset Refresh Eligibility which runs weekly (OOB) check if the useful life is exceeded or not. If exceeded, if flags the "Eligible for Refresh " field to yes. My question is, is there any way that we can created REQ/ RITM...
Hi, I have a requirement to configure the Agent mobile app to show the Asset Lifecycle Category (Hardware Inventory Stock Order, RMA Order, Reclaim asset, etc.,). I found a way to add the category in the Agent app. But when I analyzed the client's ag...
How to import data from excel sheet in catalog msvr
Hi All,Greetings!Is there any way to use Remediation Feature OOB from HAM & SAM Perspective?I have gone through different ServiceNow doc links, however not able to understand from where should we start to do POC of this feature.If anyone can help me ...
Is there any way to change the description and picture when select from a "Select Box"? Thanks.
Hi All,We have one table 'ABC' we have existing table level read ACL with 'PQR' role, Now I want to create one field level write ACL on ABC table can I use same role which is there in read ACL or do I need to use the different role foe field level wr...
W
In the 'cmdb_ci_computer' table, I've identified around 150 duplicate CIs based on serial numbers. However, when I cross-checked these CIs in all asset tables, most of the serial numbers do not have duplicates in ALM.ALM only shows one record with se...
When we're receiving consumables into our stockrooms, they're all being grouped together based on model. For example, if we have 50 ConsumableModel10 in stock, and then receive an additional 10 ConsumableModel10s to the same stockroom, the line will...
I am wanting to make the CI field on Change and Incident forms mandatory. My issue is when a user clicks the magnifying glass there is an option to create a new CI. I do not want user able to create CIs. How do I remove the create new option on the l...
We have a situation where a client created assets where the model categories were blank, and then created cis. The issue, now that we've corrected the categories, is how to add the cis that exist in the correct classes to the existing assets?
Hi, I am having one business rule to check the serial number entered, if the serial number already exists for another asset in the list then the insert action for the new record will abort and should display the error msg with the asset name whose se...
