stasnek

I tried the links below and it didn’t help Here is a picture of his config tab

You guys are a great help to me. So I ran it for one name and it seemed to work. After I took out the rest of the names I noticed it left all the comas in the table. I ran a trigger test and it seemed to work. There were only 8 entries with the…

My version of solarwinds does not have the same lay out yours does

I’m new to Solarwinds. How would I find that info?

Ok so with this it will only remove the specific names in the string and leave all others there ?

I did the custom properties again and it is still failing the same way.

Thanks for the help

Thanks for the help

I want to delete not replace.

Thanks but you missed the first part of the string.

Tried this and it didn’t work

integrated AD authentication is what we are using.

Mine His Subject: Re: - New users are not able to access config tab with full admin access thwack<thwack.solarwinds.com/index.jspa> New users are not able to access config tab with full admin access created by zzz<thwack.solarwinds.com/.../zzz> in Network Performance Monitor - View the full…

I do not want to replace I want to remove. Would this work ? update ActionDefinitions set Target = remove ( CAST(Target as nvarchar(4000)), 'ac12456@att.com', --string you are searching for - to be replaced )

@Richard Nicholson Can you tell me how to open the custom properties you want to see. This is what I found. 1017 10.80.40.6 MEXMEC375048E Cisco Mexico City MX

OMG...it worked perfect!!!!!! I also had to run Title to make them match but it worked perfect njoylif!!!! When I get the distribution email I will run it again with that. You just made my day sir!! update ActionDefinitions set Target = replace ( CAST(Target as nvarchar(4000)), 'oneil_brown@campbellsoup.com', --string you…

I followed the custom properties again and it is still failing the same way. I sent you the word doc.

@njoylif i'll wait for as long as it's needed... : ) @mhavey I did do the steps you out lined earlier and it did not help. But maybe I did something wrong. i will go back over them again. I'm not sure but we thought maybe the wacked out database was causing problems. As for the moving of the data base we will be doing that…

I was afraid you were gonna say that : ( Oh well. So i'm going to wait for the distribution list to be made from our mail folks and start to do it manually. This surely has been interesting to say the least. I still have the problem with the invalid trigger. The machine is running poorly, all the memory on the machine is…

The problem is every alert has different people in it. But Oneil was the first one in every alert. So I need to replace o'Neil but keep all the different folks in the alerts.

OK database is cleaned up and we have 26 gig of disk space. So now I'm back to my original problem and I'm hope to beable to run the Update ActionDefinitions Set Target = 'To:youremail@yourdomain.com CC: BCC: SMTPServer:yourSMTPserver SMTPPort:25 EnableSSL:False Format:HTML' Where ActionType = 'Email' But I do not 100%…

I think I need some of the data for Audit compliance.

I would like to thank you all for trying to help out. I opened a case with solarwinds. With the help of my AD guy we were able to see that PolicyCacheResults is 15 gig with a 2 gig index. The old admin had a clear old configs job and he only keep the last 10 configs. I do not have enough disk space to do a clean up of the…

Mharvey....Nice... I will try that after the database clean up. We are setting up a mail distribution list. So we will change the name to like solarwinds@campbell_soup.com. Then add the network people to it. The problem is all the remote sites want emails also. So there names are site specific, hence all the alert…

We have maybe 200 Cisco router and switches, No firewalls. I would like to only keep 1 years worth of data.

OK so I contacted my intel/AD/programming guru. He was showing me some stuff. The real problem is the HDD with the database is full and seems to have stop working September 22. So he/I are running a data base cleanup and integrity check on the data base. He also showed me and gave me access to the perfmon data base and I…

I could not see where to uplaod a word doc.

I just emailed you guys with a word doc with the error.

No DB admin, I'm all by my self. Solarwinds came in and set this up for them. I was going to go into each alert and add my name but I'm getting an error with that also.