The most recent content from our members.
Hi all, I have a SWQL query to get my VMware datastore serial numbers, vcenter servers, cluster and the vendor, i ideally need to strip out everything in the vendor column after the first '(' but cant get it to work, im fairly new to SQL/SWQL, so any advise would be amazing, SWQL query is below: SELECT…
Hey Folks - I want to nest this swql below in the alert swql trigger condition, but the SELECT statement is pre hard-coded within the alert trigger condition. It is basically monitoring a sum of 10 values then checking if the sum value is greater that 650 SELECT value FROM (SELECT SUM(data.NumericData) as value FROM…
I have customers that come to me with reports with information from our SW database from years past asking for the SQL Query. The Reports they have were made through the Web Console. I know how to find the table name and column when I have something to go off of, but what if I dont know what table or column the information…
Greetings, We are trying to run a WMI query that detects the total amount of jobs currently in the print queue which we have done, but are also wanting to detect whether the printer has errors or is offline so that these are ignored. Is there a way to have more than one table in the FROM clause of the query? SELECT Jobs…
Hi I'm trying to take advantage of the message function int he SQL User Experience Monitor which is described here SQL Server User Experience monitor . This allows me to pass a text field into your component similar to the PowerShell component. Basically my SQL query is running a COUNT function on the column OperationName…
I dont know if this is a bug or if i am just seeing things but two times this has happend to me so far in the last 2 weeks and i cannot seem to duplcate the problem. I was clicking on list resources for one of our nodes and on this node only a few resources are being monitored. but all of the resoruces showed up as being…
Hi guys. I am in need for an alert that will trigger a VBScript that will update some values in an Orion table. We have two views defined - one view for all our internet connections and one view for all our servers. Once the internet connection dies I do not want to see the servers in that office marked as dead too as that…
I just wrote a question howto do a VBScript that updates some values in the Orion database once a trigger is activated but my main question must be - why can't we choose to run a SQL query in the alert? Wouldn't that be something many people could use? I know I could as that would be much easier than making a VBScript…
It looks like you're new here. Sign in or register to get started.