to follow, share, and participate in this community. Not a member? Join Now!
I am attempting to monitor the orchestration count from my BizTalk Server using a SQL Query in Solarwinds. I am using the following SQL Query: SET NOCOUNT ON SET TRANSACTION ISOLATION LEVEL READ COMMITTED SE... I am unable to add any exclusions with the built in PowerShell Log monitor. Can I get a modified script to check for the word error in a log file, but exclude any line that has the following text "erro|gcp_payment" Is there a simple way to monitor file locks in Solarwinds? I'm looking to get the number of file locks on files in a specified folder, and if I can the name of the file and the user(s) on it. A few weeks ago I made a post in the SAM forum about the need to monitor XenApp LoginsEnabled through PowerShell. See Citrix XenApp 6.5 - Need to monitor "LoginsEnabled". aLTeReGo suggested I try the script lab instea... --below script will give result set of audit events SELECT DISTINCT DATEADD(hh, -7, ae.[TimeLoggedUtc]) TimeLogged ,ae.[AccountID] ,ae.[AuditEventMessage] [Audit Event] FROM... --find nodeids from Nodes tables-- SELECT NodeID from [SolarWindsOrion].[dbo].[Nodes] WHERE Caption IN ('Server1', 'Server2', 'Server3', etc) --below script will clear the events and leave very critical/down alerts... --since Containers_AlertsAndReportsData is a view, run sp_helptext on Containers_AlertsAndReportsData, you can add more columns as needed-- SELECT caar.GroupName AS Group_Name, caar.GroupStatusDescription A... --find ContainerID-- SELECT * FROM [SolarwindsOrion].[dbo].[Containers] WITH (NOLOCK) --run the below with BEGIN TRAN-- BEGIN TRAN UPDATE n SET n.Unmanaged=1 FROM &nbs... Hi, can someone point me to a sql statment that generates a list of nodes which a member of a certain group? @SW Team: For future use it might be good to have some views (i.e. one per objecttype) with these i... Seems script for ADLockout only works if I have one line of string: It will work for onlty the last line of this "ou=IT people,ou=users,ou=site" I want it to look thru all the strings of OU's. Do I need to... Hi All Has anyone had any experience of monitoring multiple PGP certs on a LINUX server using SAM? I have to do this and I have had a browse through Thwack, but couldn't find anything. Chatting wi... hello- first time using solarwinds SAM and running into problem with creating alerts for my SQL server to get notification regarding problems with sql databases, sql backups,etc. the alerts comes through but not getti... This script will help you to turn on port security on selected device on selected port. and if you know than you can do some minor change in script and make your own script. I am trying to setup a apm template to monitor som aspects of SCCM update deployments to servers. the one part i need help on is formatting the pending update returned values. The PS string to return the pendi... I am not a scripter so I need to see an example of how you would modify this default filter line to query several different OU in a domain including child OUs. The reason is to find out only specific locked out ... This is an example script from my toolkit that helps me to quickly review the various different ways of performing date math in sql server. Demo available here Hi guys, As we all know that events are triggered as alerts and then alerts gets acknowledged/reset/deleted. I would like to learn more what exactly happens when an alert is acknowledged ? I believe it gets re... I am creating a stored procedure to iterate all servers linked to the current server and grab the version information as pulled from the remote server. This method is probably not the most efficient way to walk ... This is a file i use during audits to quickly enumerate my SQL servers from the auditors perspective. Rather odd approach but once you have been through an audit .... methods and procedures will boggle your mind... a few examples of parameterized sql grant statements. I'll add more if suggestions provided.