mirror of https://github.com/kacos2000/Queries
You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
37 lines
1.2 KiB
SQL
37 lines
1.2 KiB
SQL
-- Home\Library\Accounts
|
|
|
|
Select
|
|
datetime('2001-01-01', zaccount.zdate || ' seconds') as 'AccDate',
|
|
datetime('2001-01-01', zaccount.ZLASTCREDENTIALRENEWALREJECTIONDATE || ' seconds') as 'RenewalRejection',
|
|
ZACCOUNTTYPE.ZACCOUNTTYPEDESCRIPTION as 'AccTypeDescription',
|
|
ZACCOUNTTYPE.ZIDENTIFIER as 'AccountIdentifier',
|
|
zaccount.ZUSERNAME as 'Username',
|
|
zaccount.ZACCOUNTDESCRIPTION as 'Description',
|
|
case zaccount.ZACTIVE
|
|
when 0 then 'No'
|
|
when 1 then 'Yes'
|
|
end as 'Active',
|
|
case zaccount.ZAUTHENTICATED
|
|
when 0 then 'No'
|
|
when 1 then 'Yes'
|
|
end as 'Authenticated',
|
|
case zaccount.ZSUPPORTSAUTHENTICATION
|
|
when 0 then 'No'
|
|
when 1 then 'Yes'
|
|
end as 'SupportsAuth',
|
|
zaccount.ZAUTHENTICATIONTYPE as 'AuthenticationType',
|
|
ZACCOUNTTYPE.ZCREDENTIALTYPE as 'CredentialType',
|
|
ZACCOUNTPROPERTY.ZKEY as 'key',
|
|
case zaccount.ZVISIBLE
|
|
when 0 then 'No'
|
|
when 1 then 'Yes'
|
|
end as 'AccVisible',
|
|
zaccount.ZIDENTIFIER as 'Identifier',
|
|
zaccount.ZOWNINGBUNDLEID as 'OwningBundleID'
|
|
|
|
|
|
from zaccount
|
|
join ZACCOUNTTYPE on ZACCOUNTTYPE.Z_PK = zaccount.'ZACCOUNTTYPE'
|
|
join ZACCOUNTPROPERTY on ZACCOUNTPROPERTY.Z_PK = zaccount.Z_OPT
|
|
|
|
order by AccDate desc |