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.

Name		Name	Last commit message	Last commit date
Latest commit History 33 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 - label hierarchy two levels.sql		computers - label hierarchy two levels.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 assigned to users in given department.sql		computers assigned to users in given department.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

Skyflash/K1000-Database-Queries

Folders and files

Latest commit

History