Forum Discussion
Excel file error
I have a problem in an excel file in format 97-2003. It worked and opened good, suddenly when trying to open it gives me message file error: data may have been lost, the text only in cells don't appear. The file size approximately 39 Mb, the file was first established in excel 2010 and I save it as 97-2003 from about 4 years, and continue working on it on excel 2007, till this problem appears.
5 Replies
This will get you very close to what you are after.
Even if you do need a client-side filter to get rid of a few strays (I found one in my sample set), the volume returned from Microsoft will still be greatly reduced which may make a noticeable difference depending on how large your environment is.
Example that pulls enabled users without client-side filtering:
Get-CsOnlineUser -LdapFilter "(&(objectCategory=person)(!userAccountControl:1.2.840.113556.1.4.803:=2)(!proxyAddresses=sip:*))" | Select-Object ObjectId, @{n="AccountEnabled"; e={ -not $_.UserAccountControl.Contains("AccountDisabled") }}, Enabled, UserPrincipalName, SipAddressExample that pulls enabled users with client-side filtering:
Get-CsOnlineUser -LdapFilter "(&(objectCategory=person)(!userAccountControl:1.2.840.113556.1.4.803:=2)(!proxyAddresses=sip:*))" | Where-Object { -not $_.SipAddress } | Select-Object ObjectId, @{n="AccountEnabled"; e={ -not $_.UserAccountControl.Contains("AccountDisabled") }}, Enabled, UserPrincipalName, SipAddressCheers,
Lain
- Similar example using standard filter.
Get-CSOnlineUser -Filter {enabled -eq 'true' -and (msExchRecipientTypeDetails -eq '1' -or msExchRecipientTypeDetails -eq '2147483648') -and ProxyAddresses -like 'sip:*'}
You can go to town on the filter, and also use searchbase to limit the scope.
- You can always filter client-side?
