Jump to content

TonyPags

Members
  • Content Count

    24
  • Joined

  • Last visited

Community Reputation

1 Neutral

My Information

  • Location
    NYC
  • Agent Count
    > 6000 Agents

Converted

Recent Profile Visitors

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

  1. I am by no means an expert on this RC/SRSS stuff. I am only able to make tweaks to lists, never was able to get a chart like this limited, I've tried. You might want to check out this page: https://www.gavsto.com/category/labtech/report-center/ And hit up Gavin on the MSP Geek Slack or ping him here for any specific questions. Such a nice gentleman that Gavin is. The basic idea is to figure out what data sources are populating that graph. Then make sure that ALL of them are limited to your date range. I've tried this on the patch compliance report but was not able to figure it
  2. For example, the patch history report shows all patch activity, but we wanted JUST INSTALLED patches from the past month. So we added this "Where SQL" to the patch history data source: DateDiff(Now(), PatchingDate) <= 31 AND (PatchingResult = 'Success' OR PatchingResult = 'In Progress') This can be found from the Report Designer toolbar (Edit Data Source). From the Data Source editor, choose the Query item you want to limit and click Edit button. I attached a screenshot @247itsupport Whatever you put in this text field will limit the results from that table only. If your data i
  3. Sir Darren sent me this on Slack, so I can't take credit. Putting it here for eternity. >> Just poking at (link to my comment): The function you want is called FIND_IN_SET .. I haven't tested this, but it should be something like this: -- I DID NOT TEST THIS YET DELIMITER $$ CREATE TRIGGER `mycompany_computers_illegalMACs` BEFORE UPDATE ON `labtech`.`computers` FOR EACH ROW BEGIN IF( SELECT COUNT(*)=0 FROM lt_web_servers_config WHERE FIND_IN_SET(NEW.mac,MACSignupBlackList)>0 ) AND OLD.mac IS NOT NULL THEN
  4. Everything worked great, in tests. When it came time for LT script engine to run the query that changes the value, it fails. I set the query to a variable and ran that while logging it, to ensure the query is what I expect, looks good, still fails. Pulling the query the script used from the log and running it in mysql worked fine. Any known issues doing this in the LT function?
  5. Yes sir, this table grouped by stage looks like it matches reality. I just hope I can edit these values and it will work without any other changes. Since it's not an EDF value I should be careful here. To the lab...
  6. I'm struggling to build a working script that changes the patching stage on a device (test/pilot/production). This should be easy, like any EDF. ExtraData set value does not work. Looking deeper into the issue, the table with extrafielddata doesn't match device patching screens. So where is the data really stored? You might be tempted to say, "ummm, Tony, all EDFs are in extrafielddata," to which I would reply "Yes Darren 😁 I already tried using the extradata set value function and selecting the patching stage item. That didn't seem to work. I can see the new record in the extrafielddat
  7. Yeah thanks. I do see some 2-hour gaps in that first log. Nothing suspect in the other two. I'll open a ticket with them about this. You probably saved me a few days of back-and-forth with them, so thanks!
  8. Hi all, We have auto-join groups and I was making some config changes earlier this morning that affected the membership of these groups. Pretty standard EDF stuff. Later in the day, well after that 26min refresh that is supposed to happen automatically, I see these devices I made changes to in the group listed as "not in group" but "will join group". I forced it by clicking the auto-join now button. And that seems to work OK, as expected. How do I check to see if this automatic group thing is working as it should?
  9. What if a "non-functional" agent is functional? Do I reinstall that agent and make sure it's re-registered under a new ID or something? Also, 2a makes no sense to me, why are we using old password moving forward?
  10. I have a status to report. After adding the trigger a week ago, I was down to 1 remaining record using an illegal MAC address today. Not too shabby! I manually updated that record and now I have 0. So I can finally test to see if that inv_ table I mentioned has any effect on agent signup. I have disabled my script which purges illegal MACs from that inv table and I waited for it to repopulate. While waiting, I checked out the h_agentsignups table for issues. -- Get-MacSignupIssues SELECT COUNT(h.computerid) AS Count, h.Computerid, h.clientid,GROUP_CONCAT(DISTINCT h.name) AS Names
  11. Good idea. Not sure how I would accomplish that but worth a ponder.
  12. I added my condition to OP's trigger to avoid manually editing the list of MACs every time you want to change it. Instead it pulls the list from the MAC Signup Blacklist, which is the native place to store these MACs. DELIMITER $$ CREATE TRIGGER `mycompany_computers_illegalMACs` BEFORE UPDATE ON `labtech`.`computers` FOR EACH ROW BEGIN IF( SELECT CONCAT( '\'', REPLACE( ( SELECT MACSignupBlackList FROM lt_web_servers_config WHERE MACSignupBlackList LIKE '%-%' ),
  13. Hey @Automation Theory I had a case where an agent DEFINITELY used the computers table MAC value for Mac signup, like you said. I have a few questions about this trigger for you: Are you running it, how is it working? What maintenance is required for it? For example, when you upgrade your server instance, do you verify it is still present and functional? How? I still want to find a case where I can test the opposite case: if no MACs exist in the computers table but do in the inv tables, will Mac Signup look at both tables for a match? But wi
  14. I think your trigger is good to keep those MACs out of the computers table. But I swear I had a senior tech tell me it was the inv table. Maybe it's both, in a cascade. Just thinking out loud. I'll share something I have that pulls the list of MACs from the blacklist. Maybe you can incorporate the subquery on the blacklist into your trigger, to make it a little more automatic. (I've commented out the inv table and replaced it with computers a la your trigger). SELECT * FROM computers -- SELECT * FROM inv_networkcard WHERE mac IS NOT NULL AND mac != '' AND ( SELECT CONCAT('\'',
×
×
  • Create New...