SQL Command for JAMF to repair data base and delete ghost entry

-
On Sql window :mysqlcheck --repair On command prompt cd C:\Program Files\MySQL\ On command prompt mysqlcheck -repair jamfsoftware -u root -p On command prompt mysqlcheck -u root -p --repair jamfsoftware On command prompt mysqlcheck -u root -p --optimize jamfsoftware On Sql window: select count(*) from computers; On Sql window: select count(*) from mobile_devices; On Sql window: select count(*) from computers_denormalized; On Sql window: select count(*) from mobile_devices_denormalized; On terminal : curl -k -u jssUser:jssPassword -H "Content-Type: text/xml"  https://jamfprourl/JSSResource/computers/id/117 -X DELETE curl -su username:password "https://server.name.here/JSSResource/computers/id/1024" -X DELETE On terminal : curl -s -k -u jamfadmin:Pradeep@1989 "https://jamf.expo2020.ae:8443/JSSResource/computers/id/117” -X DELETE On terminal : curl -s -k -u jamfadmin -p "https://jamf.expo2020.ae:8443/JSSResource/computers/id/117” -X DELETE On Sql window: : SELECT computer_id FROM computers On Sql window : DELETE from computers where computer_id = 117 On Sql window : select computer_id, udid, mac_address, alt_mac_address, computer_name from computers_denormalized where computer_id = ?; On Sql window : insert into computers (computer_id, udid, mac_address, alt_mac_address, computer_name, management_id) select computer_id, udid, mac_address, alt_mac_address, computer_name, management_id from computers_denormalized where computer_id = ?; curl -k -u jamfadmin:Pradeep@1989 -H "Content-Type: text/xml"  “https://jamf.expo2020.ae:8443/JSSResource/computers/id/117” -X DELETE curl -su jamfadmin:Pradeep@1989 "https://jamf.expo2020.ae:8443/JSSResource/computers/id/117” -X DELETE curl -s -k -u “jamfadmin” -Pradeep@1989 "https://jamf.expo2020.ae:8443/JSSResource/computers/id/117” -X DELETE url -s -k -u jamfadmin -p "https://url/JSSResource/computers/id/117” -X DELETE

Comments

Post a Comment

Popular posts from this blog

Restore macOS Server from a Time Machine backup

-
Image
In macOS Server, service data can be stored on a non-startup volume. The steps to restore from a Time Machine backup depend on whether your data was stored on the startup (boot) volume or a non-startup volume.  When restoring, restore from a local Time Machine backup. If you try to restore from a network-based Time Machine backup, not all settings will be restored correctly. If service data is on the startup volume, or only the startup volume is being restored Make sure the Time Machine backup drive is connected. Start up your server using  macOS Recovery . You can use an internal Recovery HD, Internet Recovery, an external  Recovery Drive , or the  Recovery partition of your Time Machine backup . Select Restore from Time Machine Backup and follow the onscreen instructions for restoring the volume. If you used the Mail service before restoring, toggle the Mail service off and back on in Server app.  If service data is on a non-...
Read more

JAMF Server Upgrade process

-
Upgrading JSS Upgrading the JAMF Software Server (JSS) involves the following steps: 1. Prepare to upgrade. 2. Run the JSS Installer. 3. Finalize the upgrade and revert server settings. Note: The JSS Installer cannot be used to upgrade the JSS v8.1 or earlier. Prepare the JSS Installer Download the JSS Installer from JAMF Nation. 1. Connect to JAMF Nation 2. Go to My Assets. 3. Show Alternative Download (Click for Which OS want to download default for mac available.) 4. Down load the file in the server. (Both main server and DMZ if using DMZ) Note- If upgrading from version 9 to 10.5 first need to upgrade to 10.0 then 10.5. Step 1: Prepare to Upgrade Ensure the following: • You are logged in as a local administrator, not as a domain administrator. • Apache Tomcat is stopped. Tom Cat Start using command line On Mac Stop--sudo launchctl unload /Library/LaunchDaemons/com.jamfsoftware.tomcat.plist Start-- sudo launchctl load /Library/LaunchDaemons/com.jamfsoftware....
Read more

Creating a Custom Installer for Mac (PKG Package)

-
Image
While Identity Finder is distributed from the IdentityFinder.com website as a dmg, modification to the dmg or application bundle contained therein is not supported.  Any organization using the Mac client must create and deploy a custom Installer Package that can include a custom xml file, license file, and other supplementary files as well as configure the endpoint service application. The only supported method for creating a custom Installer Package is to use the Identity Finder Client Custom PKG Builder (PKGBuilder) application referenced by and attached to this article.  This application uses pkgbuild, productbuild, and productsign, which are all included with Mac OS. Note : Mac clients prior to version 8 cannot read the package format created by this tool. Therefore: Packages created with this tool can be used for new installations of version 8 of the Mac client. Packages created with this tool can be used for manual upgrades of any version of existing client inst...
Read more