Write

Know exactly what is in each MyGeotab database

For Geotab operations teams who need a reliable device and add-in inventory for a customer database.

Geotab MyAdmin database device inventory

What devices and add-ins are in the contoso_fleet database?

contoso_fleet has 148 devices on contract and 146 reporting, so 2 need a look. - Plans: 120 ProPlus, 28 Pro, 3 terminated - Shared out: 12 devices to contoso_audit - Add-ins: Driver Coaching (active, 96 enrolled), Fuel Tracker (active, 40 enrolled) - Mismatch: G9E1F2A3B4C5 and G9D6E7F8A9B0 are on contract but not reporting here Want me to look up where those two devices report now?

Geotab MyAdmin

Sample figures. Your results come from your own account.

geotab-myadmin-get-current-device-database

geotab-myadmin-get-device-contract

geotab-myadmin-get-device-database-name

geotab-myadmin-get-device-add-in

On this page

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Geotab MyAdmin

Run it on your own Geotab MyAdmin data.

Connect Geotab MyAdmin, pick your AI tool and paste the prompt.

The problem

Device lists for one database disagree

Knowing what is in a MyGeotab database means combining several MyAdmin views: devices reporting there, contracts pointing at it, devices shared out and add-ins installed. When those lists disagree, nobody notices until a vehicle goes missing.

Without PopdockAI

List devices reporting to the database
List contracts assigned to it separately
Check sharing and add-ins on other screens
Miss the device that is in one list only

With PopdockAI

Devices, contracts, sharing and add-ins are read together
Counts by plan, device type and termination are reported
Devices in one list but not the other are flagged
It only reads and asks you to check the name if nothing is found

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt

**Objective:** Produce an inventory of database `{database}`: the devices in it, their plans, which are shared in or out, and which add-ins it runs.

**Step 1: Devices**

Call `geotab-myadmin-get-current-device-database` with database = {database} and `geotab-myadmin-get-device-contract` with database = {database}.

**Step 2: Sharing**

Call `geotab-myadmin-get-device-database-name` with owner-database = {database}. Devices with shared databases are shared out.

**Step 3: Add-ins**

Call `geotab-myadmin-get-device-add-in` with database = {database}.

**Step 4: Report**

* Counts: devices, by device plan, by device type, terminated.
* Devices shared to other databases (serial, shared databases).
* Add-ins installed (name, status, enrolled devices, auto-enroll).
* Devices in the contract list for this database but not in the current-database list, or the reverse.

**Rules & Guidelines:**

* This is a read-only job. Do NOT call any write tool: no `geotab-myadmin-change-device-billing-plan`, `geotab-myadmin-terminate-device-billing`, `geotab-myadmin-share-device`, `geotab-myadmin-update-device-contracts`, `geotab-myadmin-enroll-device-from-add-in`, `geotab-myadmin-unenroll-device-from-add-in` or any other action tool.

**Validation:**

* If no device is found for {database}, check the spelling with the user and stop.

Who it's for

One answer, three teams that use it

Support specialists

Explain a missing vehicle

Devices that appear in one list but not the other point straight at the cause.

Why might a vehicle be missing from fabrikam_fleet? Show devices that are in one list but not the other.

Fleet administrators

Know what a database holds

Counts by plan and device type, plus sharing and add-ins, in one answer.

Give me the device inventory for the northwind_ops database by plan and device type.

Account managers

Prepare a customer review

A full inventory with add-ins and enrolled counts is ready before you meet the customer.

What devices, sharing and add-ins does contoso_fleet have right now?

How it works

What PopdockAI does when you ask

You name a database and your AI assistant builds a cross checked inventory of it. Mismatches that cause support calls are listed.

Ask

You name the MyGeotab database.

Your AI tool

Collect

It reads devices, contracts, sharing and add-ins for that database.

geotab-myadmin-get-current-device-database

geotab-myadmin-get-device-contract

geotab-myadmin-get-device-database-name

geotab-myadmin-get-device-add-in

Compare

It finds devices in one list but not the other.

No items found.

Report

You get counts, sharing, add-ins and the mismatches.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Geotab MyAdmin and one secure connection to your AI tool. No code, no exports.

get-data

geotab-myadmin-get-current-device-database

Returns the MyGeotab database each device currently reports to, from the Geotab MyAdmin connector. Filter by: device-serial, database, vin. Returns up to the requested number of records.

get-data

geotab-myadmin-get-device-contract

Returns device contracts (device, plan, dates and termination status) from the Geotab MyAdmin connector. Filter by: purchase-order-number, database, start-date.to, start-date.from, device-plan, device-type, terminated, device-serial. Returns up to the requested number of records.

get-data

geotab-myadmin-get-device-database-name

Returns each device's owner database and any databases it is shared with, from the Geotab MyAdmin connector. Filter by: device-serial, owner-database. Returns up to the requested number of records.

get-data

geotab-myadmin-get-device-add-in

Returns the add-ins installed on each database, with status and enrolled device counts, from the Geotab MyAdmin connector. Filter by: database, add-in.contains, solution-id, status, add-in. Returns up to the requested number of records.

Read only.Nothing in Geotab MyAdmin Changes

This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.

The outcome

A complete picture of every database

Related use cases

More ways to put this data to work

Geotab MyAdmin device profile

Ask your AI about a Geotab device serial and get its contract, databases, add-ins, pending changes and this month of billing in one profile.

Learn More

Manage Geotab MyAdmin add-in enrollment

Ask your AI to enroll or unenroll devices in a Geotab add-in; it finds the IDs, confirms with you and shows the audit trail.

Learn More

Open a Geotab MyAdmin device support case

Ask your AI to open a Geotab support case for a device; it gathers the device details, drafts the ticket and submits after you confirm.

Learn More

Geotab MyAdmin auto-request review

Ask your AI to review recent Geotab device-contract auto-requests and get the failed and stuck ones with their errors.

Learn More

Geotab MyAdmin billing anomaly audit

Ask your AI to audit a month of Geotab MyAdmin billing and get high charges, terminated devices still billed and credits without charges.

Learn More

One prompt template with infinite possibilities.

‍

Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.

Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.