fellowsm

Comments

  • Excellent - the group by was a hangover and yes totally not needed as I was running against a singular nodeid. Thanks for your perseverance all working fine now
    in NULL return in SWQL query in alerts ? Comment by fellowsm April 2017
  • Can you share the whole query , cheers Mike Fellows | Senior OSS Specialist Direct: 07701319753 | Mobile: 07701319753 E-mail: Mike.Fellows@telent.com | Web: www.telent.com<http://www.telent.com> telent Technology Services Ltd. Registered in England. No 703317. Registered Office: Point 3, Haywood Road, Warwick, CV34 5AH,…
    in NULL return in SWQL query in alerts ? Comment by fellowsm April 2017
  • Ok here is a run from this morning against a node with interfaces that match and one that has no matching – isnull.jpg this is output from SWQL studio and this is from the edit action screen On ${N=Generic;M=DateTime;F=DateTime} ACCS Interface count=${N=SWQL;M=SELECT isnull(count(*),0) as Comments FROM orion.npm.Interfaces…
    in NULL return in SWQL query in alerts ? Comment by fellowsm April 2017
  • This is what I thought I was doing – the SWQL/SQL just doesn’t work when there is a 0 count Mike Fellows | Senior OSS Specialist Direct: 07701319753 | Mobile: 07701319753 E-mail: Mike.Fellows@telent.com | Web: www.telent.com<http://www.telent.com> telent Technology Services Ltd. Registered in England. No 703317. Registered…
    in NULL return in SWQL query in alerts ? Comment by fellowsm April 2017
  • Here you go, changing a custom property as part of an alarm, counting the interfaces that match the criteria and updating the customer variable to reflect the number Mike Fellows | Senior OSS Specialist Direct: 07701319753 | Mobile: 07701319753 E-mail: Mike.Fellows@telent.com | Web: www.telent.com<http://www.telent.com>…
    in NULL return in SWQL query in alerts ? Comment by fellowsm April 2017
  • Richard Thanks for the update will have a play and see what I can get Mike Mike Fellows | Senior OSS Specialist Direct: 07701319753 | Mobile: 07701319753 E-mail: Mike.Fellows@telent.com | Web: www.telent.com<http://www.telent.com> telent Technology Services Ltd. Registered in England. No 703317. Registered Office: Point 3,…
    in How do traps from unmanaged devices get handled ? Comment by fellowsm February 2017
  • I haven’t looked at this yet but will take a look thanks, also looking at some custom code to push ticket number and updates back into the alert Mike Mike Fellows | Senior OSS Specialist Direct: 07701319753 | Mobile: 07701319753 E-mail: Mike.Fellows@telent.com | Web: www.telent.com<http://www.telent.com> telent Technology…
    in I'm trying to create Remedy tickets from alerts Comment by fellowsm February 2017
  • Hello, This runs in SWQL but still doesn’t return a NULL when the output is null SELECT ISNULL(count(*),0) as Comments FROM Orion.NPM.Interfaces where (Interfaces.AdminStatus = 1) and (Interfaces.NodeId = 2596 ) and (Interfaces.InterfaceAlias like '%ACCS%' ) group by Nodeid} In the alarm it just fills the custom variable…
    in NULL return in SWQL query in alerts ? Comment by fellowsm April 2017
  • Tried an isnull works in SWQL studio just not when invoke as an update in the event Mike Fellows | Senior OSS Specialist Direct: 07701319753 | Mobile: 07701319753 E-mail: Mike.Fellows@telent.com | Web: www.telent.com<http://www.telent.com> telent Technology Services Ltd. Registered in England. No 703317. Registered Office:…
    in NULL return in SWQL query in alerts ? Comment by fellowsm April 2017
  • Hello this is what is in the alert On ${N=Generic;M=DateTime;F=DateTime} ACCS Interface count=$ ) and (Interfaces.InterfaceAlias like '%ACCS%' ) group by Nodeid} Which works when there is matching interface(s) but when there are no entries this SQL get posted into the custom field like this , node 3624 has 4 matching /f’s…
    in NULL return in SWQL query in alerts ? Comment by fellowsm April 2017
  • Sja Cheers Mike Mike Fellows | Senior OSS Specialist Direct: 07701319753 | Mobile: 07701319753 E-mail: Mike.Fellows@telent.com | Web: www.telent.com<http://www.telent.com> telent Technology Services Ltd. Registered in England. No 703317. Registered Office: Point 3, Haywood Road, Warwick, CV34 5AH, England telent Technology…
    in How do traps from unmanaged devices get handled ? Comment by fellowsm February 2017
  • Richard So unsolicited traps are stored – can I write some SWQL to report on NODEID = 0 ? Mike Mike Fellows | Senior OSS Specialist Direct: 07701319753 | Mobile: 07701319753 E-mail: Mike.Fellows@telent.com | Web: www.telent.com<http://www.telent.com> telent Technology Services Ltd. Registered in England. No 703317.…
    in How do traps from unmanaged devices get handled ? Comment by fellowsm January 2017
  • Curtisi Ok I think I shouldn’t have posted in LEM I’ll try NPM – all I want to do is take an event in SolarWinds, format a structured email to a Remedy webserver and cut a ticket, and then read back in the response to pull the ticket number and add that to the event. Mike Mike Fellows | Senior OSS Specialist Direct:…
    in I'm trying to create Remedy tickets from alerts Comment by fellowsm February 2017
  • Curtisi I’m hoping to generate an email from an event in NPM so wasn’t planning on using LEM (not on purpose anyway ) Just all the reading I’ve done seems to show WHD being an email receiver – If I could receive an email back into NPM that would be good. I’m new to SW and we have installed 12.0.1 so not sure if some of the…
    in I'm trying to create Remedy tickets from alerts Comment by fellowsm February 2017
  • I've got a similar issue, I'm running some SQL in an alert when a node comes up to count the interfaces that are admin up and contain the text ACCS which work fine, unless the node doesn't have any matching interfaces then it just shows the SQL - I'm putting the interface count into a custom field as below. I've tried…
    in What is the SWQL needed to retrieve the events listed on main page? Comment by fellowsm March 2017
  • ok closing this just realised i'm only running windows 7 so not meeting minimum requirements - doh ! 
    in network atlas issues Comment by fellowsm February 2017
Avatar