Jump to content
[[Template core/front/profile/profileHeader is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]]

Community Reputation

0 Neutral

My Information

  • Agent Count
    Less than 100

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hello Forum, I need to check all Chrome extensions, is there a way to get the extensions list? Is there some script or plugin to get that list on all agents? Does anyone have some instructions to get the list from cli? Thanks in advance.
  2. Th answer is to select Multiline property on that object.
  3. Hello, I remember last year I tried RMM tool to send commands through screenconnect(Control) and it worked. I tried to make some things yesterday and it failed. this is what I am getting. I do not know if this plugin is still working or if something changed. We have an OnPremise server (2019.5(Patch 5)). Thanks in advance. PS C:\Users\vgarza> Invoke-RestMethod -Method Post -Uri 'https://sc.mydomain.com/App_Extensions/741ca49a-34ff-4b74-8a5e-beb2102b5646/Service.ashx/ExecuteCommand' -Body '["XXXXX", "XXX", "ipconfig", "10"]' -ContentType 'application/json' Invoke-RestMethod : The resource cannot be found. body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Consolas","Lucida Console",Monospace;font-size:11pt;margin:0;padding:0.5em;line-height:14pt} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; } @media screen and (max-width: 639px) { pre { width: 440px; overflow: auto; white-space: pre-wrap; word-wrap: break-word; } } @media screen and (max-width: 479px) { pre { width: 280px; } } Server Error in '/' Application. The resource cannot be found. Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable.  Please review the following URL and make sure that it is spelled correctly. Requested URL: /App_Extensions/741ca49a-34ff-4b74-8a5e-beb2102b5646/Service.ashx/ExecuteCommand At line:1 char:1 + Invoke-RestMethod -Method Post -Uri 'https://sc.mydomain.com ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException + FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeRestMethodCommand PS C:\Users\vgarza>
  4. Hello everybody, I am working on a report with MACs. We are running a command to get the update status. The output of that command could be several lines (with carriage return). I am saving that information on the DB (longtext) . If I make a SELECT to that table on the DB and I see the carriage return (I see the brake line). I tried to detect wich CR is save on the DB with these queries: SELECT * FROM tbl_bt_mac_updates WHERE UpdateStatus REGEXP "\r\n"; SELECT * FROM tbl_bt_mac_updates WHERE UpdateStatus REGEXP "\r"; SELECT * FROM tbl_bt_mac_updates WHERE UpdateStatus REGEXP "\n"; -- <- Good It seems that the \n is save on the DB because it returns rows. I tried to create a report on LT. The information is there but without carriage return. Everything is in one line. I tried to create a view on the DB to replace that \n, where is part of the query: SELECT `tbl_bt_mac_updates`.`ComputerID` AS `ComputerID`, `tbl_bt_mac_updates`.`UpdateStatus` AS `UpdateStatus`, REPLACE(`tbl_bt_mac_updates`.`UpdateStatus`,'\n','\r\n') AS `UpdateStatusRN`, REPLACE(`tbl_bt_mac_updates`.`UpdateStatus`,'\n','\r') AS `UpdateStatusR`, `tbl_bt_mac_updates`.`TimeGen` AS `TimeGen` FROM `tbl_bt_mac_updates` Report Center shows one line anyway. I tried to use a "Calculate Field" and use the replace function like this: Replace( [UpdateStatus] , '\n' , '-' ) It doesn't work. I tried different ways to use the replace but it never match. If I replace any other letter the replace function works fine but it never shows any line brake on the report. Can someone help me on this? Thanks in advance.
  5. Hello guys, Does anyone know how to get the information for Apple products?
  6. Well, I was working with my list and I got this error message: Update-MissingHPWarranties -HPAPIKey "TyI6keB5L14YfiYjXWmx0XExavKZJDAf" -HPAPISecret "z0VOHaEwkcg0FUUt" Invoke-RestMethod : {"fault":{"faultstring":"Rate limit quota violation. Quota limit exceeded. Identifier : 9536adec-74c9-460d-95ce-e2e3ae995276","detail":{"errorcode":"policies.ratelimit.QuotaViolation"}}} At line:67 char:20 + $JobResponse = Invoke-RestMethod -Method Post -body ($HPSNs | ConvertTo-Json ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException + FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeRestMethodCommand PS C:\Users\vgarza> I will make a research, if someone already resolved this, I will appreciate the help.
  7. Yes, it works, but I had to reduce to 100 items.
  8. There was an error loading the report data for report id 81 (NAME MISSING): 0: An assembly with the same simple name 'ReportCenterPlugin, Version=2.0.12000.10, Culture=neutral, PublicKeyToken=null has already been imported. Try removing on of the references or sing them to enable side-by-side.' What I did is a view on the DB, I create a Report from Template (Computer Base), I added my view in the data source and I made the relationship. In the ReportHeader SubReport, I changed the report source url to my HeaderReportLandscape. Does someone knows something about this error? Thanks in advance.
  9. Thanks for this script, it works great. I notice that in the beginning the script always failed on the same function (Update-MissingHPWarranties). The HP JobResponse estimatedTime was 20296 for 1000 workstations. I reduced the number with a LIMIT on the SQL and then I realize that we have some items with a blank SN, I am not sure if that breaks the script under Update-MissingHPWarranties but I put a filter in the SQL query. This was my final SQL query: $HPComputers = get-Labtechdata -query "select BiosVer from computers where biosmfg like 'h%p%' and (warrantyend = 0 or assetdate = 0) AND BiosVer != '' LIMIT 200" I add these entry to know more about the time: After the JobResponse: Write-Output "HP JobResponse estimatedTime: $JobDelay JobID: $JobID" After Assert-LabtechQuery: Write-Output "UPDATE: '$($_.sn)' WarrantyEnd='$($_.endDate.SubString(0,10))', AssetDate='$($_.startDate.SubString(0,10))' " I am not sure if the blank items break the function or were a timeout for too many items. I leave it with 200 items at the moment. Thanks again for this script and this is my little apportation.
  10. I need to check if a software is installed, but this software is installed as current user. If I run the clasic "if software installed", it does not detect it. Do you know any clue how to detect this software? Thanks in advance.
  11. Dear Darren, I am sorry for the delay in my answer. The query is this: SELECT CONCAT('<PRE>',REPLACE(REPLACE(REPLACE(REPLACE(`eventlogs`.`Message`,'\0','<AAA>'),'\r','<BBB>'),'\n','<NNN>'),'\r\n','<RRRNNN>'),'</PRE>') AS `message` FROM `eventlogs` LIMIT 1000; I do not find any match. That tell me that there are not any \0, \r,\n or \n\r. Thanks in advance.
  12. Dear Darren, I appreciate so much your comments. I worked with your examples but there is no difference. Your example gave me an idea. Replace any character \0, \r, \n or \r\n by anything else in the Database (Not in Report Center). This to know if those characters are presents in the DB, there are not any of these on the DB. I run this query: REPLACE(REPLACE(REPLACE(`v_bt_eventlogs_prevday`.`Message`,'\0','<NULL>'),'\r','<RRR>'),'<NNN>','<RRRNNN>') I did not see any replace match on the output. That's mean the DB does not have any of these special characters. If someone knows something different about this, please, let me know. Any comment will be great. Thanks in advance.
  13. Hello Foro, I hope all are well. I had been searching how to insert the carry return on the report but I had tried too many things that I am not sure if it is possible. You are my last resource. I am working on the Event Log table, the message field. I need to create a report for some events Ids and display the message. Some security messages have too many lines and the problem is that it is difficult to read because there is not Carry return, the report itself it could not help too much because it will be difficult to read in this format. I would like to insert the original carry return on the message. I am using the REPLACE function with a Calculated Field and I tried with \r \n and it does not work. If I replace any string with other it works, but I am not sure if there is some kind of symbol in the message field to be replaced with a carrier return. Do you know if this is possible? If there is a way to find the CR in the message field? Or if you know if there is a CR in that field? It will help me a lot!. Thanks in advance!!!.
  14. Hello, Does someone knows if can I install/run the data view creator on v12?
  15. I found the solution for this questions. I had to reinstall the Screenconnect. It gives me the option to open an SSH redirector.
×
×
  • Create New...