Jump to content

DNSMN

Members
  • Content Count

    11
  • Joined

  • Last visited

Community Reputation

0 Neutral

My Information

  • Location
    Minneapolis, Minnesota
  • Agent Count
    1000+

Converted

  1. Every day we get a ticket for 4 of our clients that have StorageCraft loaded on their servers. The ticket message is simply "Shadow Protect is Expired on CompanyName\ServerName at Servers Alert! There is a critical problem to attend to." Looking at each server the software is activated and working well. I see the monitor checks the following "computers.flags & 256 = 0 and (Select count(*) from spjobs where computerid = computers.computerid) > 0". Hoping someone could help me understand what is happening here and how I might resolve this false flag ticket every morning outside of disabling the monitor on that server. Thanks for any assistance
  2. DNSMN

    McAfee SaaS Custom Tab

    That did it thanks! Only problem is McAfee has a bunch of js scripts running on their portal pages. There's a bunch of "Object doesn't support property or method" errors trying to run it inside of LabTech window. Some areas are accessible but others not without errors on the page. Also doesn't appear to be a way to pass the username/password on to the portal so it auto logs in. What web browser does LabTech use? My local default? Is there anyway to get it to remember logon credentials like a regular web browser does?
  3. DNSMN

    McAfee SaaS Custom Tab

    Hello, I'm trying to setup a custom tab for our clients McAfee SasS web portals (TabType-WebPage). A problem i'm running into is that some clients are on portal.mxlogic.com and some are console.mxlogic.com. To specify this by client, I created a EDF under the Client/Info tab and called it McAfeeSaaS. I've inserted the URL specific to the client as above and am trying to call this URL from the Custom Tab URL field with a variable. Nothing seems to come up as desired. Can someone advise how I make this happen? Thanks in advance!
  4. DNSMN

    Custom Tab/EDF SQL Queries

    I see that in the v_extradatalocations table there are columns for Servers Under Contract and Workstations Under Contract, I presume this is the data I want. Would I need to do a variable set like the other software counts or is there a more simple SQL command I can use in the script to just grab the data in these locations and populate my EDFs based on the client we're looking at?
  5. DNSMN

    Custom Tab/EDF SQL Queries

    Would be great to be able to just pull the counts in from the Client/Ignite/Contract Totals tab fields. I could do a set variable like the ESET and StorageCraft agents, or how do I pull these field counts over into my EDFs on my custom tab?
  6. DNSMN

    Custom Tab/EDF SQL Queries

    I've gotten the ESET and Shadow Protect agents to report into my EDFs great. Just trying to figure out how to pull the LabTech agent count and populate my EDFs. What would my Variable Set SQL Query be to count LabTech workstation vs server agents? Would i grab these counts the same was as the others? Any help would be much appreciated!
  7. DNSMN

    Custom Tab/EDF SQL Queries

    Great stuff guys, thanks for the direction! I believe I've started getting some valid results. I have scheduled my script to run every 3 hours as it doesn't appear to be picking up everything yet. I have Skip Offline Agents unchecked in advanced scheduling but it seems to be missing some of them. I'll let it run for a day or two and see if things are picking up right over time. Thanks again!
  8. DNSMN

    Custom Tab/EDF SQL Queries

    Ok, might be getting somewhere I created a new script IF: True 1 Function: Variable Set Set Type: SQL Query Parameter: SELECT COUNT(*) FROM software WHERE name = 'ESET NOD32 Antivirus','ESET Smart Security','ESET Endpoint' and ComputerID IN (SELECT ComputerID from Computers WHERE ClientID='@ClientID@'); Variable Name: esetwkstncount OS: All 2 Function: ExtraData Set Value ExtraField: ESET Workstatin Agents -3 (selected from dropdown) ID: @ClientID@ Value: @esetwkstncount@ OS: All Not sure if i need anything else in the script (ie. THEN statement), but when i ran against a client i got a -9999 result in the ESET Workstation Agents EDF. So some sort of progress.
  9. DNSMN

    Custom Tab/EDF SQL Queries

    So I assume from your reply that we cannot simply just put the query in the Fill line of the Additional Fields. I saw other fields that had the ~SELECT queries in their Fill field and hoped it'd be that easy. Looking thru the LTG posts i found this http://www.labtechgeek.com/forum/viewtopic.php?f=10&t=564 and it appears to be in the direction of what i'm trying to accomplish (minus the ticket creation part). Your instruction seems pretty clear, though i'm pretty new to the scripting thing. Is there any further detail you'd be able to provide on the process to create the script and insert into the EDF?
  10. DNSMN

    Custom Tab/EDF SQL Queries

    Thanks guys, Brandon, yes i am just looking for a simple number count to fill in the EDF based on the query i put in the Dashboard>Additional Fields>Clients area. I Created my EDF and then put the query in the ToolTip or Combo Fill entry box. So in my additional fields definition for ESET Workstation Agents I have put the following ToolTip or ComboFill query but nothing is returned. Maybe i'm missing something here? ~SELECT COUNT(*) FROM software WHERE name = 'ESET NOD32 Antivirus','ESET Smart Security','ESET Endpoint' and ComputerID IN (SELECT ComputerID from Computers WHERE ClientID='@ClientID@'); Is there a lag for when the EDF will run the query in the tooltip/combo fill box? I see a refresh button on my EFT tab but that doesn't seem to do anything either. Thanks!
  11. DNSMN

    Custom Tab/EDF SQL Queries

    Hello everyone, I've created a very simple custom tab under the clients section to return some agent count values by client. The tab's all setup and I've got my EDFs all in position. I'm hoping someone can give some assistance creating some simple SQL queries to return the following values. I believe i'm thinking about this correctly in that I would want to put a ~Select type of query in the EDF Fill area... Any help would be greatly appreciated! - ESET NOD32 Desktop Agents - ESET File Security Agents - LabTech Server Agents - LabTech Workstation Agents - StorageCraft Server Agents - StorageCraft Workstation Agents
×