Forum Discussion

Lewis_Beard's avatar
Lewis_Beard
Icon for Expert rankExpert
4 days ago
Solved

WQL Query Datapoint cant do Expressions or Scripts?

Because LogicMonitor can't do Text Datapoints (correct me if I'm wrong) and because a Config Source can't run as frequently as I would like, I'm trying to find a way to essentially turn an ENUM throu...
  • Mike_Moniz's avatar
    Mike_Moniz
    4 days ago

    Would suggest switch it over to a full groovy/powershell script to collect the information. Then you can have real enums and convert the strings to numbers directly in the script. A lot of LM existing scripts this way. For example you can look at Microsoft_Windows_Services. You might be able to actually clone that one and re use it for your purposes.

    Now that I HIGHLY suggest you order your status codes from good to bad. Because thresholds can't use and/or (like "=1 or =2"). So I would order your status to be something like:

    0 StartPending
    1 Running
    2 ContinuePending
    3 PausePending
    4 Paused
    5 StopPending
    6 Stopped

    (I'm guessing the order). That way you can have a threshold of like "> 3 6". It also easier to read in a graph or color code in a table.

Mike_Moniz's avatar
Mike_Moniz
Icon for Professor rankProfessor
4 days ago

Would suggest switch it over to a full groovy/powershell script to collect the information. Then you can have real enums and convert the strings to numbers directly in the script. A lot of LM existing scripts this way. For example you can look at Microsoft_Windows_Services. You might be able to actually clone that one and re use it for your purposes.

Now that I HIGHLY suggest you order your status codes from good to bad. Because thresholds can't use and/or (like "=1 or =2"). So I would order your status to be something like:

0 StartPending
1 Running
2 ContinuePending
3 PausePending
4 Paused
5 StopPending
6 Stopped

(I'm guessing the order). That way you can have a threshold of like "> 3 6". It also easier to read in a graph or color code in a table.

  • Mike_Moniz's avatar
    Mike_Moniz
    Icon for Professor rankProfessor
    4 days ago

    I mean ">= 3 6". Also you can correct, you can't have text in a datapoint. It needs to be a number.

  • Lewis_Beard's avatar
    Lewis_Beard
    Icon for Expert rankExpert
    4 days ago

    I was so honestly locked-in on brute-forcing the clone of an existing one, that worked fine as groovy autodiscovery but WQL variable value datapoints .... That I forgot I could just go from scratch. Thanks! :)