Im looking to remove the serial number and label for the Drives in the SNMP monitor name and the alerts.  Its just more information then I need.  Currently for example it says

 

Free Disk Space in GB-P:\ Label: PageFile Serial Number 148908d1

 

I just want it to say Free Disk Space in GB-P:\

 

I tried running a sql query in the opmanger database to remove the serial number and Label.  But with no luck.  It actually screwed up the database where I had to remove the device and re-add it.  Here is the query I tried to run

 

update polleddata
set name = reverse(substring(reverse(name),23,50))

 

update polleddata
set name = left(name,4)+substring(name,11,50) where name like '%label%'

 

Is there anything else I can do.