domenicbetters
Joined 11 months ago
User Profile
User Widgets
Contributions
Is it possible to set up a password rotation policy
So I was wondering. Is it possible in LM to set up a policy that forces our users to reset their passwords every 90 days. I don’t see any options to do so in LM and I wasn’t sure if anyone out there has done so through some clever scripting. I set up something similar in ServiceNow where a scheduled script ran every day and forced a user reset if the password was over so many days old. Thanks for your helpSolved34Views3likes2CommentsRe: Is there a way to set custom property values from your groovy script in your datasource?
It seems the issue has something to do with API calls in general, and if I can get anything out of support, I’ll post an update. But for the purpose of the original post, I’d say mission accomplished. I’d guess there’s a problem with those collectors accessing the internet. In postman, there’s an option on the right that looks like “</>”. If you pop that open, it’ll auto generate simple code to make your API call. If you select cURL, you should be able to paste that into a bash shell on the collector (presuming the token in that code is recent). If that fails with a similar error, that would mean a problem on the host, not related to the collector software. Good idea, and after testing it, it works fine through powershell and bash. So looks like it is a collector issue.0Views0likes0CommentsRe: Is there a way to set custom property values from your groovy script in your datasource?
Alright, I know you’ve already got yours working but I’ve been meaning to simplifying this into a single function for years and never got around to it. Well, now I have. Hopefully the documentation is sufficient. I’m not sure it’ll fix the issue you’re having with the devices on the lab collectors, but I’d be interested to know how it goes for you. Actually, I dipped into your github and tested out your version already. I love how it’s cleaned up but unfortunately, in regard to that issue with the two training devices, that unknownhostexception persists. It seems the issue has something to do with API calls in general, and if I can get anything out of support, I’ll post an update. But for the purpose of the original post, I’d say mission accomplished.0Views1like0CommentsRe: Is there a way to set custom property values from your groovy script in your datasource?
Well, I still haven’t been able to resolve this issue with a few of our training devices. That aside, the modified script works as intended and I finally have a solution to my original problem posed in first message of this post. Huge thanks to Stuart for letting me bug him every step of the way. So the solution was to use API calls within int he collector attribute script inside the mysql global performance datasource. I won’t share the whole script but I will post parts that seem relevant to my issue and solution. A lot of extra imports were needed to get this working and before the base script starts i establish to GET requests to obtain info needed to get to my final GET and PUT request import groovy.sql.Sql import com.santaba.agent.groovyapi.http.*; import groovy.json.JsonSlurper; import org.apache.http.HttpEntity import org.apache.http.client.methods.CloseableHttpResponse import org.apache.http.client.methods.HttpGet import org.apache.http.client.methods.HttpPut import org.apache.http.impl.client.CloseableHttpClient import org.apache.http.impl.client.HttpClients import org.apache.http.util.EntityUtils import javax.crypto.Mac; import javax.crypto.spec.SecretKeySpec; import org.apache.commons.codec.binary.Hex; import groovy.json.*; import org.apache.http.entity.ContentType; import org.apache.http.entity.StringEntity; import org.apache.http.client.utils.URIBuilder // *** Establish API Creds *** def accessId = hostProps.get("lmaccess.id"); def accessKey = hostProps.get("lmaccess.key"); def account = 'micoresolutions'; // *** Get Datasource ID for device as string. *** def resourcePath = '/device/devices/'+hostProps.get("system.deviceID")+'/devicedatasources' def url = "https://" + account + ".logicmonitor.com" + "/santaba/rest" + resourcePath; //get current time epoch = System.currentTimeMillis(); //calculate signature requestVars = "GET" + epoch + resourcePath; hmac = Mac.getInstance("HmacSHA256"); secret = new SecretKeySpec(accessKey.getBytes(), "HmacSHA256"); hmac.init(secret); hmac_signed = Hex.encodeHexString(hmac.doFinal(requestVars.getBytes())); signature = hmac_signed.bytes.encodeBase64(); // HTTP GET CloseableHttpClient httpdsid = HttpClients.createDefault(); httpGet = new HttpGet(url); // Add custom filter values to GET Request URI uri = new URIBuilder(httpGet.getURI()) .addParameter("fields", "id") .addParameter("filter", "dataSourceName:Microsoft_SQLServer_GlobalPerformance") .build(); httpGet.setURI(uri); httpGet.addHeader("Authorization" , "LMv1 " + accessId + ":" + signature + ":" + epoch); response = httpdsid.execute(httpGet); responseBody = EntityUtils.toString(response.getEntity()); // Turn data into id string that can be inserted into next Request datapull = new JsonSlurper().parseText(responseBody.toString()); datapull = datapull.data.items.id.value.toString() datapull = datapull.replace("[","") datasouceid = datapull.replace("]","") httpdsid.close() // *** get instance ID for each instance on device *** resourcePath = "/device/devices/"+hostProps.get("system.deviceID")+"/devicedatasources/${datasouceid}/instances" url = "https://" + account + ".logicmonitor.com" + "/santaba/rest" + resourcePath; //get current time epoch = System.currentTimeMillis(); //calculate signature requestVars = "GET" + epoch + resourcePath; hmac = Mac.getInstance("HmacSHA256"); secret = new SecretKeySpec(accessKey.getBytes(), "HmacSHA256"); hmac.init(secret); hmac_signed = Hex.encodeHexString(hmac.doFinal(requestVars.getBytes())); signature = hmac_signed.bytes.encodeBase64(); // HTTP GET CloseableHttpClient httpinstanceid = HttpClients.createDefault(); httpGet = new HttpGet(url); httpGet.addHeader("Authorization" , "LMv1 " + accessId + ":" + signature + ":" + epoch); response = httpinstanceid.execute(httpGet); responseBody = EntityUtils.toString(response.getEntity()); // Male array of instance ids for final get and put request datapull = new JsonSlurper().parseText(responseBody.toString()); instanceids = datapull.data.items.id httpinstanceid.close() My final resource path ---"/device/devices/"+hostProps.get("system.deviceID")+"/devicedatasources/${datasouceid}/instances/"+instanceids requires a deviceID, a datasourceID and an instanceID. So the first get pulls the correct datasource ID and the second get uses that datasourceID to grab the instance IDs. Then Once the collector begins its SQL query loop to find the values for all those datapoints, I insert my final GET and PUT, as well as using a custom SQL query script to find the blocker info I need. if ("${counter_name}"=="Processesblocked") { // ***Follow up if statement that decides between which Put request to use based on whether there is in fact a block or not. *** if ("${cntr_value}".toInteger() > 0) { // ***For loop to cycle through each instance on the device pulled from instance array*** for(i=0; i < instanceids.size; i++) { resourcePath = "/device/devices/"+hostProps.get("system.deviceID")+"/devicedatasources/${datasouceid}/instances/"+instanceids url = "https://" + account + ".logicmonitor.com" + "/santaba/rest" + resourcePath; //get current time epoch = System.currentTimeMillis(); //calculate signature requestVars = "GET" + epoch + resourcePath; hmac = Mac.getInstance("HmacSHA256"); secret = new SecretKeySpec(accessKey.getBytes(), "HmacSHA256"); hmac.init(secret); hmac_signed = Hex.encodeHexString(hmac.doFinal(requestVars.getBytes())); signature = hmac_signed.bytes.encodeBase64(); // HTTP GET CloseableHttpClient httpinprop = HttpClients.createDefault(); httpGet = new HttpGet(url); httpGet.addHeader("Authorization" , "LMv1 " + accessId + ":" + signature + ":" + epoch); response = httpinprop.execute(httpGet); responseBody = EntityUtils.toString(response.getEntity()); code = response.getStatusLine().getStatusCode(); datapull = new JsonSlurper().parseText(responseBody.toString()); instanceprops = datapull.data // ***if statement to ensure that the put request only applies to current SQL instance iteration by matching the instance displayname property with the SQL instancename *** if ("${instanceprops.displayName}"=="${instanceName}") { // ***SQL query to find blocker data*** outputBlocks = runQuery("""SELECT SPID, BLOCKED, REPLACE (REPLACE (T.TEXT, CHAR(10), ' '), CHAR (13), ' ' ) AS BATCH INTO #T FROM sys.sysprocesses R CROSS APPLY sys.dm_exec_sql_text(R.SQL_HANDLE) T; WITH BLOCKERS (SPID, BLOCKED, LEVEL, BATCH) AS (SELECT SPID, BLOCKED, CAST (REPLICATE ('0', 4-LEN (CAST (SPID AS VARCHAR))) + CAST (SPID AS VARCHAR) AS VARCHAR (1000)) AS LEVEL, BATCH FROM #T R WHERE (BLOCKED = 0 OR BLOCKED = SPID) AND EXISTS (SELECT * FROM #T R2 WHERE R2.BLOCKED = R.SPID AND R2.BLOCKED <> R2.SPID) UNION ALL SELECT R.SPID, R.BLOCKED, CAST (BLOCKERS.LEVEL + RIGHT (CAST ((1000 + R.SPID) AS VARCHAR (100)), 4) AS VARCHAR (1000)) AS LEVEL, R.BATCH FROM #T AS R INNER JOIN BLOCKERS ON R.BLOCKED = BLOCKERS.SPID WHERE R.BLOCKED > 0 AND R.BLOCKED <> R.SPID ) SELECT N' ' + REPLICATE (N'| ', LEN (LEVEL)/4 - 1) + CASE WHEN (LEN(LEVEL)/4 - 1) = 0 THEN 'HEAD - ' ELSE '|------ ' END + CAST (SPID AS NVARCHAR (10)) + N' ' + BATCH AS BLOCKING_TREE FROM BLOCKERS ORDER BY LEVEL ASC DROP TABLE #T;""", conn.connection, debug) blockerid = "${outputBlocks.data.blocking_tree}" instanceprops.customProperties = [[name:"blockerdetails", value:"${blockerid}"]] instanceprops = JsonOutput.toJson(instanceprops) StringEntity params = new StringEntity(instanceprops,ContentType.APPLICATION_JSON) epoch = System.currentTimeMillis(); //get current time requestVars = "PUT" + epoch + instanceprops + resourcePath; hmac = Mac.getInstance("HmacSHA256"); secret = new SecretKeySpec(accessKey.getBytes(), "HmacSHA256"); hmac.init(secret); hmac_signed = Hex.encodeHexString(hmac.doFinal(requestVars.getBytes())); signature = hmac_signed.bytes.encodeBase64(); httpPut = new HttpPut(url); httpPut.addHeader("Authorization" , "LMv1 " + accessId + ":" + signature + ":" + epoch); httpPut.setHeader("Accept", "application/json"); httpPut.setHeader("Content-type", "application/json"); httpPut.setEntity(params); responsePut = httpinprop.execute(httpPut); responseBodyPut = EntityUtils.toString(responsePut.getEntity()); codePut = responsePut.getStatusLine().getStatusCode(); } httpinprop.close() } } else { for(i=0; i < instanceids.size; i++) { resourcePath = "/device/devices/"+hostProps.get("system.deviceID")+"/devicedatasources/${datasouceid}/instances/"+instanceids url = "https://" + account + ".logicmonitor.com" + "/santaba/rest" + resourcePath; //get current time epoch = System.currentTimeMillis(); //calculate signature requestVars = "GET" + epoch + resourcePath; hmac = Mac.getInstance("HmacSHA256"); secret = new SecretKeySpec(accessKey.getBytes(), "HmacSHA256"); hmac.init(secret); hmac_signed = Hex.encodeHexString(hmac.doFinal(requestVars.getBytes())); signature = hmac_signed.bytes.encodeBase64(); // HTTP GET CloseableHttpClient httpinprop = HttpClients.createDefault(); httpGet = new HttpGet(url); httpGet.addHeader("Authorization" , "LMv1 " + accessId + ":" + signature + ":" + epoch); response = httpinprop.execute(httpGet); responseBody = EntityUtils.toString(response.getEntity()); code = response.getStatusLine().getStatusCode(); datapull = new JsonSlurper().parseText(responseBody.toString()); instanceprops = datapull.data // ***if statement to ensure that the put request only applies to current SQL instance iteration by matching the instance displayname property with the SQL instancename *** if ("${instanceprops.displayName}"=="${instanceName}") { blockerid = "No Blocks" instanceprops.customProperties = [[name:"blockerdetails", value:"${blockerid}"]] instanceprops = JsonOutput.toJson(instanceprops) StringEntity params = new StringEntity(instanceprops,ContentType.APPLICATION_JSON) epoch = System.currentTimeMillis(); //get current time requestVars = "PUT" + epoch + instanceprops + resourcePath; hmac = Mac.getInstance("HmacSHA256"); secret = new SecretKeySpec(accessKey.getBytes(), "HmacSHA256"); hmac.init(secret); hmac_signed = Hex.encodeHexString(hmac.doFinal(requestVars.getBytes())); signature = hmac_signed.bytes.encodeBase64(); httpPut = new HttpPut(url); httpPut.addHeader("Authorization" , "LMv1 " + accessId + ":" + signature + ":" + epoch); httpPut.setHeader("Accept", "application/json"); httpPut.setHeader("Content-type", "application/json"); httpPut.setEntity(params); responsePut = httpinprop.execute(httpPut); responseBodyPut = EntityUtils.toString(responsePut.getEntity()); codePut = responsePut.getStatusLine().getStatusCode(); } httpinprop.close() } Now when the collector does it’s thing it will run that SQL query and per instance, update my custom property with either the blocker details or “no blocks”.0Views0likes0CommentsRe: Is there a way to set custom property values from your groovy script in your datasource?
As a follow up, this specifically seems to only be affecting our other two virtual machines in our training environment here at the office Are those devices monitored by a different collector that might have different DNS/internet path? hmmm they are monitored by their own collectors. I am gonna go through them both to see if anything is different or maybe I messed something up in all my previous tests and failed scriptings.0Views0likes0CommentsRe: Is there a way to set custom property values from your groovy script in your datasource?
So the script works great for my main test device. However the collector does keep throwing that error “java.net.UnknownHostException: micoresolutions.logicmonitor.com” When I run it on another device. It is still the same account info so nothing should be different about it. As a follow up, this specifically seems to only be affecting our other two virtual machines in our training environment here at the office0Views0likes0Comments