ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login
    1. Topics
    2. Tags
    3. query
    Log in to post
    • All categories
    • DustinB3403D

      OSX Terminal Serial Number

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion osx terminal details investigation query macos
      12
      2 Votes
      12 Posts
      1k Views
      scottalanmillerS

      @RojoLoco and that's what I appreciates about you RL.

    • EddieJenningsE

      SCCM Queries

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion sccm system center configuration manager query wql sccm 1610
      4
      2 Votes
      4 Posts
      847 Views
      EddieJenningsE

      @obsolesce said in SCCM Queries:

      https://docs.microsoft.com/en-us/sccm/develop/reference/core/clients/manage/sms_r_system-server-wmi-class

      And I see many of the attributes I can include in a query there. So when a query is run, this class is generated, which populates itself with the relevant data from the database, then the query selects the necessary data from this on-the-fly generated class. Does that seem right?

    • scottalanmillerS

      osTicket: Basic Ticket Report of All Tickets with Subject

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion osticket osticket 1.10 mysql sql mariadb report query
      7
      3 Votes
      7 Posts
      3k Views
      scottalanmillerS

      @bbigford said in osTicket: Basic Ticket Report of All Tickets with Subject:

      Since there is no inner or outter join specified, inner join is obviously being used where 'join' is specified (outter join having to be explicitly defined where an outter join is needed). How come you explicitly specify 'inner join' at the bottom when you could just use 'join' again as your inner join?

      Obviously join and inner join accomplish the same thing, just curious why one is not explicitly defined and the other is.

      I expanded on something done by someone from the osTicket team. it was some weird stylistic choice that they made and I just followed.

    • scottalanmillerS

      osTicket: How to Query a Ticket Subject for a Report

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion osticket osticket 1.10 mysql mariadb sql query report
      1
      3 Votes
      1 Posts
      1k Views
      No one has replied
    • 1 / 1