Mit diesem SQL-Befehl könnt Ihr nach Usern suchen, von denen Ihr nur die IMEI oder PIN habt. Da es die SQL-Felder schon zulassen, ist dies natürlich auch für das Model möglich, somit könntet Ihr also eine kleine Auswertung aller User machen, die z.B. das Model 9700 im Besitz haben – dafür müsste lediglich die „where-Zeile“ abgeändert werden. Ist im Prinzip das selbe Spielchen, wie die Suche nach der Telefonnummer.
select uc.DisplayName,
uc.PIN,
ds.ModelName,
ds.AppsVer,
ds.PlatformVer,
ds.PhoneNumber,
ds.IMEI,
ds.HomeNetwork,
ds.ESN,
ds.ICCID,
ds.IMSI,
ds.FlashSize,
ds.ITPolicyName,
ds.ITPolicyTime from UserConfig uc
left join SyncDeviceMgmtSummary ds on uc.Id=ds.UserConfigId
where ds.IMEI like ‚%346828.02.891037.4%‘
order by uc.DisplayName
Für die Abfrage nach der PIN müsst ihr where ds.IMEI like ‚%346828.02.891037.4%‘ in where uc.PIN like ‚%215FB35%‘ ändern, wobei die PIN natürlich frei wählbar ist.
Hi,
dieser SQL-Select kann aber nur die Besmgmt db abfragen oder kann ich das über meinem Bold auch benutzen?
Bölde Frage ;-)
Manche Kommentare sind halt mal vollkommen überflüssig!
Ich versteh die Frage von Bart gar nicht, sorry :)
You want to have a statement or proof that you did
spend your individual well being care insurance coverage.
Personal Tax An abundance of benefits in having your accountant file your business and personal taxes will come out.
If you attach a corrected Form 1040, be sure to write ‚Amended‘ across
the front of both pages of the 1040.
my web site; boca raton classic cars
There aren’t too many ocean two person sit in fishing kayaks out on the
market. Top mount refrigerators are excellent for storage space as they have wide
shelves and a lot of door shelves for drinks and condiments.
They could also garnish a car or a boat this way and put it into
storage.
Here is my blog: marine fridge freezer nz
I am the webmaster of a internet site that is committed to Jane Norman Dresses.
Dater shows women who are controlled, comfortable with their bodies, confident and
who break the passive stereotypical image of woman. Now,
in reality, Jiang Hao has been arranged outside the
site in their own good wind and rain do not care through the
Alexander matrix, it can barely be regarded as a certain power of self-protection, but
Jiang Hao was also not at all to relax this principle.
My blog post boutique Prom dresses for teens
Thanks to my father who informed me regarding this webpage, this
blog is in fact remarkable.
Ear deformities, especially in children can become a target for the less caring children resulting in the child being ridiculed and teased.
These use a number of techniques to move the natural oils down their hair such as boar bristle brushing and ’scritching‘ between washes.
We live in a climate that gets hot and humid and there are many activities to choose from.
My blog low level laser hair therapy equipment