function get-tenantlistindb {
\n param(
\n [switch]$all
\n )
\n $SQLInstance = "localhost\\SQLExpress"
\n $SQLDatabase = "Microsoft365"
\n $sqlqr = "select * from [Microsoft365].[dbo].[tenants]"
\n if (-not $all) {
\n $sqlqr += " where active='1'"
\n }
\n $tenants = invoke-sqlcmd -query $sqlqr -ServerInstance $SQLInstance -Database $SQLDatabase
\n $tenants
\n}<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"
Now that we have our tenants listed in a database table, listing them is quite easy. Added a switch that allow you to also list deleted\/removed tenants. function get-tenantlistindb { param( [switch]$all ) $SQLInstance = "localhost\\SQLExpress" $SQLDatabase = "Microsoft365" $sqlqr = … Continue reading Get-tenantlistindb (from previous post)<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"Get-tenantlistindb (from previous post)","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[72,74,2,48],"tags":[],"class_list":["post-990","post","type-post","status-publish","format-standard","hentry","category-azure","category-csp","category-development","category-powershell"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t