Hello,

yes, it needs to be created in the reporting section.
The package needs to be applied to the entire fleet.
Be sure to keep the double percent signs (%) to avoid SQL-to-Python interpretation.

Small fix for posts already having the KB:

# -*- coding: utf-8 -*-
from setuphelpers import *

r"""
Usable WAPT package functions: install(), uninstall(), session_setup(), audit(), update_package()

"""
# Declaring global variables - Warnings: 1) WAPT context is only available in package ...

Hello,

regarding the KB5002700 issue related to Office 2016, Microsoft suggests using the binary here: https://www.microsoft.com/en-us/download/details.aspx?id=108113

Here is a package code to handle both 32-bit and 64-bit Office:

# -*- coding: utf-8 -*-
from setuphelpers import *

r ...

Hello,

here is a package that retrieves a computer's description from Active Directory and modifies the local computer description.

Package: tis-set-ad-description-to-registry
Version: 1.3-4
Architecture: All
Section: Base
Priority: Optional
Name: Set AD description to registry
categories ...

Hello,

following the logic of the audit-dmi and audit-wmi packages, I propose this package:

# -*- coding: utf-8 -*-
from setuphelpers import *


def install():
pass


def audit():
try:
data_host_info = host_info()
except Exception as e:
data_host_info = {"status": str(e)}
WAPT.write_audit_data_if ...

Hello,

in addition to using the audit-host package, I propose this query which allows you to find which machine a monitor is connected to,
using its serial number.


/* Replace the serial number to find the machine */

SELECT
h.computer_name,
h.last_seen_on,
h.computer_type ...

Hello, when you put the UUID in your query it appears

Improvement for displaying it in inventory filters:

Hello,

here are two queries that retrieve a list of workstation models, grouped by model.

Global:

SELECT
manufacturer,
productname,
COUNT(*) AS NbMachines
FROM
hosts
GROUP BY
manufacturer, productname;


OR:

SELECT
manufacturer,
productname,
COUNT(*) AS NbMachines
FROM ...

Hello,

here is a query that retrieves:
- the list of applications
- grouped by version number
- indicating the machines with that version
- from a specific OU

SELECT
hs.name AS Software_Name,
hs.version AS Software_Version,
COUNT(DISTINCT h.computer_fqdn) AS NbMachines,
STRING_AGG ...