🔍 📑 A collection of MySQL queries for the Dell KACE K1000 appliance.
Switch branches/tags
Nothing to show
Clone or download
Pull request Compare This branch is 3 commits ahead of csteelatgburg:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
.gitattributes
.gitignore
Find PCs with LMS service disabled.sql
Find Seven Installs.sql
Labels with a software asset.sql
Mac OS computers without purchase date.sql
README.md
Smart Device Label based on logged-in user label.sql
Software with uploaded file but no Managed Install.sql
Softwares recently uploaded on Service Desk with label.sql
Users created in past seven days.sql
Users with changed AD Description in last seven days.sql
asset history for a computer.sql
assets with department.sql
average days to close ticket per category.sql
check if computer connected to kbox.sql
classroom assets query for banner import.sql
classroom assets.sql
client upgrades in the past seven days.sql
computer ages in labels in a given parent label.sql
computer asset owner changes.sql
computer assets assigned to sub-location.sql
computer assets without po created date.sql
computer data for replacement projections.sql
computer labels with spss .sql
computers - adobe license expiry.sql
computers - apple computers with expiring adobe license.sql
computers - apple computers with warranty and purchase dates.sql
computers - apple warranty out of coverage using purchaseinfo.sql
computers - asset location and liaison.sql
computers - computers with expiring adobe license.sql
computers - count of computers by OS.sql
computers - disk information.sql
computers - firmware versions installed on computer models.sql
computers - hard drive usage per department.sql
computers - lab systems with lab and building.sql
computers - name-ip-ou custom inventory rule.sql
computers - user folder size.sql
computers assigned to non active employees.sql
computers bootcamp and virtual not checked in for 3 months.sql
computers connected but not running papercut.sql
computers connected running pc-client.exe.sql
computers deploying patches.sql
computers ending in inst not in lab vlans.sql
computers having wrong serial number in apple purchase date file.sql
computers in acad and admin vlan with location and liaison.sql
computers in publab or publab2 with static ip address.sql
computers in publab2 vlan.sql
computers missing critical security patches.sql
computers named for a user with a different owner.sql
computers not named for a user assigned to a person.sql
computers on acad and admin vlan with static ip.sql
computers on acad and admin vlans using dhcp.sql
computers pending reboot for patching.sql
computers that have installed a given software title in the past seven days.sql
computers that have not checked in for 30 days with liaisons.sql
computers that have not checked in for seven days.sql
computers that have not restarted in 30 days.sql
computers with InSync Mac installed but not running.sql
computers with InSync installed and running process.sql
computers with Office 2013 and 2010 that have checked in within 60 days.sql
computers with acrobat pro installed.sql
computers with administrators in bosler.sql
computers with administrators removing strings.sql
computers with administrators.sql
computers with adobe software installed.sql
computers with changes in ram in the past day.sql
computers with column showing software installed.sql
computers with dell ship and warranty dates and PO.sql
computers with dell ship and warranty dates in a given label.sql
computers with dell ship and warranty dates in a given parent label.sql
computers with dell ship and warranty dates.sql
computers with duplicate MAC addresses.sql
computers with failed managed installs.sql
computers with flash version less than specific version.sql
computers with less than 10GB free on main drive.sql
computers with local spss license.sql
computers with location and liaison.sql
computers with more than 20 uninstalled patches.sql
computers with more than 200GB used on c drive.sql
computers with no assigned user.sql
computers with owner information.sql
computers with papercut installed with user logged in not running papercut.sql
computers with patches installed and still needed.sql
computers with patches not installed.sql
computers with purchase date and replacement date with a given label.sql
computers with purchase date and replacement date.sql
computers with purchase date.sql
computers with specific patch not installed.sql
computers with spss license status.sql
computers with stata license file info.sql
computers with the same hardware address.sql
computers with two patches installed.sql
computers with upgrade status label.sql
computers with uptime greater than 45 days.sql
computers with warranty expiring in 60 days.sql
computers without a po date with po info from another computer in same dell order.sql
computers without location asset assigned.sql
computers without office 2013.sql
computers without upgrade status label and no POCreated date.sql
computers without upgrade status label and out of warranty.sql
computers without upgrade status label.sql
count of computers in acad and admin vlans by location.sql
count of computers in old vlans by building.sql
count of computers running Google Chrome by version.sql
count of malware tickets per year and month.sql
count of tickets per week in a given range.sql
count of tickets with keywords per month.sql
employee status changes in past month showing assigned assets.sql
find computer name changes for given serial number.sql
find computers that have others as their beginning.sql
location labels with asset information.sql
machines with location label.sql
managed install - attempt count for computers for a given MI.sql
number of computers per location label with liaison.sql
number of malware tickets per user.sql
patches include per patch schedule.sql
patches needed for a computer.sql
patches not installed on any computers.sql
patches patched and not patched per machine for a given patching schedule.sql
patches reported installed in inventory for given computer.sql
patches with number patched.sql
patching - compliance for machines in a label - critical patches released 60 to 30 days ago.sql
patching - computers with a given label missing patches .sql
patching - machines that need WannaCry.sql
patching - status counts for specific schedule.sql
patching - status for a specific patch.sql
patching - status of may 2017 critical patch schedule.sql
patching - status of specific patch.sql
patching phase report.sql
patching run date with patching log date.sql
patching status error.sql
patching status for machine with a label.sql
patching status for patch production.sql
printer toner levels and alerts - lexmark.sql
printer toner levels and alerts - toshiba.sql
printer toner levels and alerts.sql
script - failed mac password change.sql
script log details for a given script id.sql
script most recent log.sql
scripting - latest run times with schedule.sql
scripting - script schedules.sql
select max version by padding last subset.sql
software - flash player new versions in past day.sql
software - java new versions in past day.sql
software - new mac OS versions.sql
software installed on a given machine.sql
software installed on computers with a given label.sql
software installed on given computers in past days.sql
software usage average per month.sql
software usage for acrobat pro.sql
software version on machines (Flash in Bosler).sql
software version on machines (Skype in Bosler).sql
system name to department label to department location.sql
temp.sql
ticket changes per given id.sql
ticket counts for submitter is an owner per queue.sql
ticket counts per top level category.sql
ticket status changes.sql
tickets - average days to close ticket per category per month.sql
tickets - count of open tickets grouped by queue and owner.sql
tickets - count of tickets changed per user in the past month.sql
tickets - count of tickets opened by month via email or not.sql
tickets - count of tickets opened per day and location in past week.sql
tickets - count of tickets per category per month this year.sql
tickets - count of tickets per category.sql
tickets - count of tickets per queue and priority not changed in four hours.sql
tickets - work hours for previous seven days grouped by category and owner.sql
tickets by month and priority not closed in two days with average time to close.sql
tickets by month and priority with average time to close.sql
tickets closed in past seven days by specific users.sql
tickets closed in past seven days with submitter labels.sql
tickets closed per month this year that were open for more than seven days.sql
tickets closed with average days to close per month per category.sql
tickets closed with average days to close per month.sql
tickets closed within 48 hours from previous quarter.sql
tickets closed within given intervals from previous two weeks.sql
tickets closed within given intervals grouped by week and priority.sql
tickets count of tickets open per day in previous month.sql
tickets due in two days.sql
tickets from past 30 days showing number and average time open grouped by owner.sql
tickets not changed in past 4 hours.sql
tickets not updated in four hours.sql
tickets open and unassigned for 1 day.sql
tickets opened and closed per month.sql
tickets opened and still opened and unassigned from previous month.sql
tickets opened and still opened and unassigned.sql
tickets opened in past seven days.sql
tickets opened per month between certain hours.sql
tickets opened via email and not assigned to an owner for two hours.sql
tickets per priority with average time to first owner change.sql
tickets reopened in past 30 days.sql
tickets reopened multiple times.sql
tickets showing last change by owner.sql
tickets showing owner and approval changes.sql
tickets that are open with most recent comment.sql
tickets transferred in past month.sql
tickets with creator and submitter.sql
tickets with keywords.sql
tickets with more than five updates in the past hour.sql
tickets with new status for over one hour in the previous 30 days.sql
tickets with new status for over two hours.sql
tickets with row count.sql
tickets with submitter having a specific label.sql
users in specific roles.sql
users that are owners per queue.sql
users with desktop and laptop computers.sql
users with multiple computers.sql
users with tickets from last month.sql
work per technician showing start stop difference and adjustment hours sums.sql

README.md

K1000-Database-Queries

These queries were mostly written for Dickinson College and the Dell KACE K1000 appliance. Many of them contain specific values that will only be valid for Dickinson (e.g. service desk queue IDs and custom inventory rules) but they may be helpful as a reference for others. I have tried to name with with a descriptive of a title as possible.