Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

My Information

  • Location
  • Agent Count
    > 6000 Agents


  1. TonyPags

    Active Directory Reports (Tutorial)

    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?
  2. TonyPags

    Active Directory Reports (Tutorial)

    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"?
  3. TonyPags

    Active Directory Reports (Tutorial)

    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.
  4. TonyPags

    Active Directory Reports (Tutorial)

    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
  5. TonyPags

    Restricting Reports to a Date period

    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! 👻
  6. TonyPags

    Uninstall Eset Remote Administrator Agent

    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.
  7. TonyPags

    Active Directory User List

    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.