Skip to content
/ K1000-Database-Queries Public
forked from Skyflash/K1000-Database-Queries

🔍 📑 A collection of MySQL queries for the Dell KACE K1000 appliance.

10 stars 9 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

KACE-SMA-Tools/K1000-Database-Queries

BranchesTags
 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

28 Commits
.gitattributes
.gitattributes
 
 
.gitignore
.gitignore
 
 
CTR - associate computer asset owners department with asset.sql
CTR - associate computer asset owners department with asset.sql
 
 
CTR - submitter comment on closed ticket.sql
CTR - submitter comment on closed ticket.sql
 
 
CTR - tickets not changed in past 4 hours by owner.sql
CTR - tickets not changed in past 4 hours by owner.sql
 
 
Find PCs with LMS service disabled.sql
Find PCs with LMS service disabled.sql
 
 
Find Seven Installs.sql
Find Seven Installs.sql
 
 
Labels with a software asset.sql
Labels with a software asset.sql
 
 
Mac OS computers without purchase date.sql
Mac OS computers without purchase date.sql
 
 
README.md
README.md
 
 
Smart Device Label based on logged-in user label.sql
Smart Device Label based on logged-in user label.sql
 
 
SmartLabel - computers with multiple disks.sql
SmartLabel - computers with multiple disks.sql
 
 
Software with uploaded file but no Managed Install.sql
Software with uploaded file but no Managed Install.sql
 
 
Softwares recently uploaded on Service Desk with label.sql
Softwares recently uploaded on Service Desk with label.sql
 
 
Users created in past seven days.sql
Users created in past seven days.sql
 
 
Users with changed AD Description in last seven days.sql
Users with changed AD Description in last seven days.sql
 
 
asset history for a computer.sql
asset history for a computer.sql
 
 
assets - computer assets without an associated department.sql
assets - computer assets without an associated department.sql
 
 
assets with department.sql
assets with department.sql
 
 
average days to close ticket per category.sql
average days to close ticket per category.sql
 
 
check if computer connected to kbox.sql
check if computer connected to kbox.sql
 
 
classroom assets query for banner import.sql
classroom assets query for banner import.sql
 
 
classroom assets.sql
classroom assets.sql
 
 
client upgrades in the past seven days.sql
client upgrades in the past seven days.sql
 
 
computer ages in labels in a given parent label.sql
computer ages in labels in a given parent label.sql
 
 
computer asset owner changes.sql
computer asset owner changes.sql
 
 
computer assets assigned to a room or alias.sql
computer assets assigned to a room or alias.sql
 
 
computer assets assigned to sub-location.sql
computer assets assigned to sub-location.sql
 
 
computer assets without po created date.sql
computer assets without po created date.sql
 
 
computer data for replacement projections.sql
computer data for replacement projections.sql
 
 
computer labels with spss .sql
computer labels with spss .sql
 
 
computers - adobe license expiry.sql
computers - adobe license expiry.sql
 
 
computers - apple computers with expiring adobe license.sql
computers - apple computers with expiring adobe license.sql
 
 
computers - apple computers with warranty and purchase dates.sql
computers - apple computers with warranty and purchase dates.sql
 
 
computers - apple warranty out of coverage using purchaseinfo.sql
computers - apple warranty out of coverage using purchaseinfo.sql
 
 
computers - asset location and liaison.sql
computers - asset location and liaison.sql
 
 
computers - azure hybrid ad join status.sql
computers - azure hybrid ad join status.sql
 
 
computers - bios update available.sql
computers - bios update available.sql
 
 
computers - computers with expiring adobe license.sql
computers - computers with expiring adobe license.sql
 
 
computers - count of computers by OS.sql
computers - count of computers by OS.sql
 
 
computers - disk information.sql
computers - disk information.sql
 
 
computers - firmware versions installed on computer models.sql
computers - firmware versions installed on computer models.sql
 
 
computers - free disk space less than 10GB with asset location and liaison.sql
computers - free disk space less than 10GB with asset location and liaison.sql
 
 
computers - hard drive usage per department.sql
computers - hard drive usage per department.sql
 
 
computers - lab systems with lab and building.sql
computers - lab systems with lab and building.sql
 
 
computers - name-ip-ou custom inventory rule.sql
computers - name-ip-ou custom inventory rule.sql
 
 
computers - uptime broken down into minutes.sql
computers - uptime broken down into minutes.sql
 
 
computers - user folder size.sql
computers - user folder size.sql
 
 
computers assigned to adjunct faculty.sql
computers assigned to adjunct faculty.sql
 
 
computers assigned to non active employees.sql
computers assigned to non active employees.sql
 
 
computers bootcamp and virtual not checked in for 3 months.sql
computers bootcamp and virtual not checked in for 3 months.sql
 
 
computers connected but not running papercut.sql
computers connected but not running papercut.sql
 
 
computers connected running pc-client.exe.sql
computers connected running pc-client.exe.sql
 
 
computers deploying patches.sql
computers deploying patches.sql
 
 
computers ending in inst not in lab vlans.sql
computers ending in inst not in lab vlans.sql
 
 
computers having wrong serial number in apple purchase date file.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 acad and admin vlan with location and liaison.sql
 
 
computers in publab or publab2 with static ip address.sql
computers in publab or publab2 with static ip address.sql
 
 
computers in publab2 vlan.sql
computers in publab2 vlan.sql
 
 
computers missing critical security patches.sql
computers missing critical security patches.sql
 
 
computers named for a user with a different owner.sql
computers named for a user with a different owner.sql
 
 
computers not named for a user assigned to a person.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 vlan with static ip.sql
 
 
computers on acad and admin vlans using dhcp.sql
computers on acad and admin vlans using dhcp.sql
 
 
computers pending reboot for patching.sql
computers pending reboot for patching.sql
 
 
computers that have installed a given software title in the past seven days.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 30 days with liaisons.sql
 
 
computers that have not checked in for seven days.sql
computers that have not checked in for seven days.sql
 
 
computers that have not restarted in 30 days.sql
computers that have not restarted in 30 days.sql
 
 
computers with InSync Mac installed but not running.sql
computers with InSync Mac installed but not running.sql
 
 
computers with InSync installed and running process.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 Office 2013 and 2010 that have checked in within 60 days.sql
 
 
computers with acrobat pro installed.sql
computers with acrobat pro installed.sql
 
 
computers with administrators in bosler.sql
computers with administrators in bosler.sql
 
 
computers with administrators removing strings.sql
computers with administrators removing strings.sql
 
 
computers with administrators.sql
computers with administrators.sql
 
 
computers with adobe software installed.sql
computers with adobe software installed.sql
 
 
computers with changes in ram in the past day.sql
computers with changes in ram in the past day.sql
 
 
computers with column showing software installed.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 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 label.sql
 
 
computers with dell ship and warranty dates in a given parent 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 dell ship and warranty dates.sql
 
 
computers with duplicate MAC addresses.sql
computers with duplicate MAC addresses.sql
 
 
computers with failed managed installs.sql
computers with failed managed installs.sql
 
 
computers with flash version less than specific version.sql
computers with flash version less than specific version.sql
 
 
computers with less than 10GB free on main drive.sql
computers with less than 10GB free on main drive.sql
 
 
computers with local spss license.sql
computers with local spss license.sql
 
 
computers with location and liaison.sql
computers with location and liaison.sql
 
 
computers with more than 20 uninstalled patches.sql
computers with more than 20 uninstalled patches.sql
 
 
computers with more than 200GB used on c drive.sql
computers with more than 200GB used on c drive.sql
 
 
computers with no assigned user.sql
computers with no assigned user.sql
 
 
computers with owner information.sql
computers with owner information.sql
 
 
computers with papercut installed with user logged in not running papercut.sql
computers with papercut installed with user logged in not running papercut.sql
 
 
computers with patches installed and still needed.sql
computers with patches installed and still needed.sql
 
 
computers with patches not installed.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 with a given label.sql
 
 
computers with purchase date and replacement date.sql
computers with purchase date and replacement date.sql
 
 
computers with purchase date.sql
computers with purchase date.sql
 
 
computers with specific patch not installed.sql
computers with specific patch not installed.sql
 
 

Repository files navigation

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.

About

🔍 📑 A collection of MySQL queries for the Dell KACE K1000 appliance.

Topics

mysql labels smartlabel kace systemmanagement k1000

Resources

Readme
Activity
Custom properties

Stars

10 stars

Watchers

3 watching

Forks

2 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages

  • TSQL 98.8%
  • PLpgSQL 1.2%