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

  • Location
    NYC
  • Agent Count
    > 6000 Agents

Converted

  1. @Dave M, I made a RAWSQL internal monitor that looks up the MAC Blacklist as entered under the advanced server config (the WHERE clause below). Just add your MACs there and run this on All Agents. You could also hard-code your own list in the query, or pull it from a table somewhere, for example. Select DISTINCT Computers.MAC as TestValue, computers.computerid As IdentityField, computers.computerid, computers.Name as ComputerName, Convert(CONCAT(clients.name,' ',locations.name) Using utf8) As Location, acd.NoAlerts, acd.UpTimeStart, acd.UpTimeEnd FROM computers LEFT JOIN Locations ON Locations.LocationID=computers.Locationid LEFT JOIN Clients ON Clients.ClientID=Computers.clientid JOIN AgentComputerData AS acd on Computers.ComputerID=acd.ComputerID WHERE (SELECT MACSignupBlackList FROM lt_web_servers_config WHERE MACSignupBlackList LIKE '%-%') LIKE CONCAT('%',MAC,'%') AND NOT Locations.LocationID=581 AND Computers.ComputerID IN (Select Distinct ComputerID From Tcomp) AND Computers.ComputerID NOT IN (Select ComputerID from AgentIgnore Where AgentID=294883) Please note on the 3rd to last line I have something custom for my env (581 is a location I exclude from this check). Remove or modify this line for your own needs. I made this because when you blacklist a MAC, but an agent in the system already has that MAC, the blacklist doesn't block the device, since MAC signup is flaming trash.
  2. So I was able to get the reports imported and published, but I cannot run them. To get them imported I had to put back the duplicate column and keep the DomainIfoLastUpdated column named as DomainIfoLastUpdated. But something wonky happened when pasting the text from this post into Yog. Even if I used a plain text to paste and re-copy before setting that up. No matter what I did, the view would not be created, it kept giving me the error I originally got above. I had to take your query and paste it as-is into MySQL Workbench and use the intellisense there, to rewrite the lines that spit back an error. Annoying but not too difficult. What's really weird is that it gave me a duplicate column error yesterday, but today it didn't. Now, when I run the reports, all 3 of them give me this error: "Could not find file c:\Program Files (x86)\LabTech Client\PageHeaderLandscape [long GUID]'. And I confirmed this file does not exist on my PC, the web server, nor the DB server (I am split server). I re-imported the header and that didn't help any. Any ideas on that path error?
  3. Hi @rmuell01, Yes I did create the views after having some trouble (as described above). There was 1 column I had to remove from the SELECT clause in the first view, because it was a duplicate and caused an error. I don't think this would affect anything down the line since a column is a column and it doesn't matter what order they are in. Actually looking at this again, that might be it. The aliases are different. `plugin_ad_domains`.`LastUpdate` AS `lastupdate`, `plugin_ad_domains`.`LastUpdate` AS `DomainIfoLastUpdated`, Which one is right? "DomainIfoLastUpdated" looks like a typo as well. Should it be "DomainInfoLastUpdated"?
  4. I hit another roadblock importing the REPX files. The subreport imported without issue. The 3 other reports failed with a message of "There was an error loading the report. Please verify that the report is in a valid format and try again." I tried reloading the report center, no joy. I tried reloading system caches for Control Center, no joy. I closed the Control Center and cleared the caches using this script. ############# clear LTCC ################ # Close LTCC $LTCC = Get-Process ltclient -ea 0 if($LTCC){$LTCC|Stop-Process -Force} # Remove Reg Keys Get-childItem 'HKCU:\Software\LabTech\Client\Lists' | Remove-Item -Confirm:$false # Delete folders Get-Item 'C:\ProgramData\Labtech Plugins' -ea 0 | Remove-Item -Recurse -Confirm:$false -ea 0 Get-Item 'C:\ProgramData\Labtech Client\Cache' -ea 0 | Remove-Item -Recurse -Confirm:$false -ea 0 ########## end clear LTCC ################ ...no joy. I tried going directly to my web server and running the Control Center from there and importing the file, no joy. I am out of ideas.
  5. Thanks @rmuell01, I was having trouble creating views. The execute button was grayed out in the create view tab. I created a new tab and pasted the above into it. It turns out when I paste your query into the SQL editor, it's saying that the columns do not exist, but there they are as plain as day. I had my DBA look at it and he was stumped too. I took the select subquery and tried to run it, it gives errors. I tried multiple devices and clients all with an error related to the aliases. I noted that the aliases were not really needed (except for the GROUP_CONCAT function) and I took them out. Then started getting unknown column errors. I when thru line by line and recreated the columns using intellisense auto complete. Then it broke on ContactID and I couldn't get it to work by retyping it out. Error Code: 1054. Unknown column 'plugin_ad_users.ContactID' in 'field list' Then I tried about 3 more times with intellisense and it worked on the 4th try. Adding this in case someone else has the same problem but I think it's my PC, it's running slow today so maybe that had something to do with it. If at 4th you don't succeed, try again. EDIT: turns out there was also a duplicate column: plugin_ad_domains.LastUpdate
  6. You have to make a custom report for that date range (like within the last 30 days, or similar). You would add a WHERE statement to the appropriate table(s) under Data Sources. Also, Happy Halloween! 👻
  7. Hi, we had to remove ESET before installing our own AV at a few of our clients. The issue was that it couldn't be done without the uninstall password, and the only workaround was to reboot into safe mode and run a script provided on the ESET support site to remove it without the password. We eventually contacted the old MSP and were able to work with them to re-hook up their ESET plugin into our platform and push the uninstall command, that got most of them. They couldn't give us the password. It was a manual removal by field techs to get the remaining ones. Not a fun project. For your specific issue, you might want to reach out to ESET support or check their website. I would assume they have something already, given the above experience.
  8. Man this looks really cool, but the ZIP files I found on this thread have SQL in them that doesn't seem to do anything other than drop 4 views that aren't there by default, and a lot of commented out stuff. I just looked at the code, didn't run it. Is it possible to re-post the original ZIP? I'm on 12.0.12 and latest RC, if that kills my chances.
×
×
  • Create New...